Management Studio Split Tabs
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in...
2012-01-05 (first published: 2012-01-03)
3,117 reads
Blog Posts
Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,365 reads
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
750 reads
Safely Restart SQL Agent with Powershell
I recently had to enable tokens in SQL Agent across about 50 instances. Unfortunately, enabling tokens requires a SQL Agent...
2012-01-05
1,768 reads
SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,178 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,891 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,243 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a...
2012-01-04
913 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
13 reads
Difference between ETL and ELT
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,612 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers