Automating Imports from Access
Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management...
2010-03-17
879 reads
Blog Posts
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
819 reads
SQL Saturday – A Few Lessons for Future Events
I’ve been to a few SQL Saturdays, and while most have run smoothly, I have a few comments on a...
2010-03-17
876 reads
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also...
2010-03-17
6,092 reads
A Wiki Wiki
I was killing a few minutes browsing while waiting on a call, had been thinking again whether a wiki would...
2010-03-16
703 reads
Dynamically Adding and Removing Columns to a Query and Report
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
820 reads
Enabling Filestreaming in SQL Server 2008
This is a short post on enabling file streaming. I have read a few sources that cover the same topic...
2010-03-16
753 reads
How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2
After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL...
2010-03-16
1,312 reads
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
810 reads
Intel Xeon 56xx Series Westmere-EP Review
AnandTech IT has a quick review of the upcoming six-core, 32nm Intel Xeon 56xx processor, which includes several different database...
2010-03-16
1,992 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers