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
871 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
814 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
873 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,074 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
698 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
809 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
740 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,298 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
795 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,942 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers