Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,435 reads
Blog Posts
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
874 reads
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
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,084 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
700 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
814 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
750 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,306 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
800 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers