Antivirus Exclusion Policy for SQL Server
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...
2014-04-08
13,156 reads
The One Million Row T-SQL Test Harness
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,694 reads
SSIS Performance Testing
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I...
2014-04-16 (first published: 2014-04-08)
3,314 reads
One week to SQL Intersection
You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in...
2014-04-08
745 reads
Last Weeks Top “Reading” Links #78
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-07
692 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
569 reads
April 2014 – SQL Server Monthly Maintenance Checklist
image source
Make sure you start the month right by taking the time to make certain your SQL Server environment is...
2014-04-15 (first published: 2014-04-07)
3,739 reads
Decree: Set your partition offset and block size – make SQL Server faster
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,502 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
328 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
516 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Optimized Locking in SQL Server 2025
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers