The most recent content from our members.
The audience for this post are technologists who have some exposure to provisioning resources in the Azure portal, but haven’t yet started doing scripted deployments. The purpose of this post is to get started with understanding and customizing the contents of an ARM template (as opposed to doing the one-click deployment…
This month's T-SQL Tuesday is hosted by Raul Gonzalez (@SQLDoubleG), and is about Lessons Learned the Hard Way. Now, I've learned many lessons the hard way. When I started my career and transitioned from web design and server-side scripting into more focus on SQL Server, I bought a whole bunch of books; my favorites were…
In a previous life, I was responsible for a production system with somewhere around 1,500 roughly identical databases, one per client. I called it a multi-tenant system for years, but that causes strife, because many people only think of multi-tenant as a database-level concept rather than an instance-level concept. This…
On June 19th, @kekline and I presented a webinar called "Tales from Building a SQL Server in Azure." In this session, we shared experiences and lessons learned from a recent migration of our business intelligence and data warehousing environment to Azure. Key discussion topics in the webinar: * Deciding between SQL Server…
This month's T-SQL Tuesday - hosted by Matt Gordon (@sqlatspeed) - is called "Fixing Old Problems with Shiny New Toys." Matt wants us to write about how we've solved old problems in new ways afforded by enhancements to SQL Server (or new features anywhere in the stack, I would guess). Over the years I have helped a lot of…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." This is a topic near and dear to my heart; for several years I was a huge proponent of the Connect system. For a while, I even published weekly digests, where I highlighted bugs and feature requests that I thought deserved more eyeballs and…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." My T-SQL Tuesday post is about a request for Power BI, which may be a little on the edge of SQL Server as far as T-SQL Tuesday goes. I want to talk about a limitation when sorting a Stacked Chart. As I mentioned in my previously, I started to…
This month's T-SQL Tuesday is hosted by Brent Ozar (b/t), and is about those wonderful Connect requests that we want fixed/added in SQL Server. Aaron Bertrand (b/t) reminded me of one of my all-time favorites. You know when you started working with SQL Server and you'd get error messages that you couldn't figure out? One…
There are so many cool, exciting new features in SQL Server these days! Polybase, Query Store, R Services, Stretch Databases, and the list goes on! This post isn't about any of those. SQL Server Agent jobs aren't new or cool or sexy, but I honestly don't know what I'd do without them. I remember a few years back I was…
SQL Server Reporting Services (SSRS) is a little gem of the SQL Server stack, under-appreciated, but a gem nonetheless. Building a report is relatively simple, and lots of people do this. As part of the SQL Sentry suite of tools, we have a number of reports that are built-in. But what not many people realize is that we can…
It looks like you're new here. Sign in or register to get started.