|
Category: Community
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
The ‘B’ in B-Tree – Indexing in SQL Server
/
Some people advocate we should count by twelve rather than ten. This is because you can easily count the twelve segments of your fingers…
-
DBCC CLONEDATABASE
/
Often I hear developers claim that they need production data in order to properly tune their queries. There are a couple of reasons that…
-
Everything has a cost
/
Too often we end up in a conflict while trying to explain how a minimally impacting function has no true business impact. If you are…
-
T-SQL Tuesday #74 – Be the change (MERGE static data)
/
Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then…
-
Keeping up with changes to Books Online
/
Keeping up with new features of SQL Server can be a challenge. What is even more challenging, though, is keeping up with changes to…
-
Adding Your Entire Enterprise into Red-Gate SQL Multi Script Distribution List
/
RedGate sells a product call SQL Multi Script. The product allows you to asynchronously execute T-SQL scripts to large quantities of servers. There are…
-
The end of an era
/
Today is my last day working for Liberty Tax Service. Liberty took a chance on me when I was fresh out of the Navy…
-
Active sessions and block duration
/
As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of…
-
Availability Group fail-over test with PowerShell
/
I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency…
-
A first timer’s lessons learned at PASS Summit 2014
/
Me, as a #sqlfirsttimer Just one year ago I didn’t know what the PASS Summit was. What came after has been a series of serendipitous events. I…