Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,020 reads
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,020 reads
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,129 reads
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,646 reads
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,531 reads
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,598 reads
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,965 reads
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,734 reads
2012-11-15
2,038 reads
Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of...
2012-11-12 (first published: 2012-11-09)
2,763 reads
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,696 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers