Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,432 reads
How I Got my Start at Pragmatic Works
October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a...
2015-10-06
574 reads
Today at 12pm Central: #MinionEnterprise Talk – Backup Management!
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
648 reads
New Article: Loading Fixed Width Files to Staging Tables
My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...
2015-10-06
692 reads
Extended Event Management Power Tools
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...
2015-10-06
15 reads
Extended Event Management Power Tools
So far in this series I have introduced a couple of tools that are suitable for helping with the management...
2015-10-06
634 reads
Load Testing Your Storage Subsystem with Diskspd – Part III
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results....
2015-10-06
24 reads
The Future Virtualization of the Workforce - Telecommuting
Welcome to the 21st century! 20th
century habits die hard! What am I
talking about today? I’m talking about the virtuous virtue...
2015-10-06
1,505 reads
Overview of Published Articles – 2015Q3
Here is an overview of the articles I published in the third quarter of 2015.
Retrieve file sizes from the file system...
2015-10-06
476 reads
Table valued parameters (TVP)
Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...
2015-10-06
2,063 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers