SQL Server Hardware Choices Made Easy
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a...
2011-08-29
1,963 reads
Glenn Berry
New Dell Precision M4600 Mobile Workstation
After a very long wait, I finally received my new company laptop this past week, which is a very fast...
2011-08-28
1,849 reads
A Couple of Data Compression Tricks in SQL Server 2008
As I have said several times before, I am a big fan of data compression in SQL Server 2008 and...
2011-08-23
1,913 reads
SQL Server 2008 R2 RTM Cumulative Update 9
Microsoft has released Cumulative Update 9 for SQL Server 2008 R2 RTM, which is Build 10.50.1804.0. I count 26 fixes...
2011-08-19
2,096 reads
SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,508 reads
Gradually Deleting Data in SQL Server
If you have a situation where you have a very large table in SQL Server, where you need to periodically...
2011-08-13
1,612 reads
Configuring, Benchmarking and Validating an I/O Subsystem for SQL Server, Part 1
One of the main projects I have been working on lately is designing and implementing a completely new data and...
2011-08-12
1,844 reads
Microsoft SQL Server Denali CTP 3 Product Guide
Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and...
2011-08-12
1,256 reads
Corsair 16GB Flash Voyager GT USB 3.0 Review
I bought a little Corsair Flash Voyager USB 3.0 16GB USB Flash Drive at Micro Center yesterday, since most of...
2011-08-11
2,202 reads
Two New TPC-E Submissions
Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three...
2011-08-05
966 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers