I’m A SQL Server Rockstar Blogger!
SQL Server Rockstar Blogger
I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server...
2013-11-27
1,180 reads
Blog Posts
Identifying Columns to Create Index via T-SQL
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,464 reads
Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
1,106 reads
Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,686 reads
Review: The Abilene Paradox
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,331 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,577 reads
What should a candidate know about your company?
I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned...
2013-11-27 (first published: 2013-11-19)
2,065 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 5
If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...
2013-11-26 (first published: 2013-11-19)
3,854 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
445 reads
HammerDB SQL Server Benchmarking Utility
Mike Fal
Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance....
2013-11-26
1,787 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers