Quick tip, ever needed to manipulate SQL on many lines in SSMS? now you can….
Have you ever had the need to select values that are directly on the next line down but drag-and-drop selects...
2014-01-27
275 reads
Blog Posts
Security, Compliance, and SQL Server Webinar on January 29, 2014
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
979 reads
SSAS Trending KPI
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
798 reads
Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance
We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....
2014-01-27
1,768 reads
What does “challenging” really mean?
I had lunch with an old friend last week. We hadn’t spoken in a while and we were catching up...
2014-01-27
840 reads
Does @StrateSQL Need a Unicorn Tattoo?
As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks...
2014-01-26
542 reads
Master Data Services for the Beginner Part 01
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,296 reads
Master Data Services Disaster Recovery Challenges
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,588 reads
Blogtrottr – RSS to Email
Anyone who is a fan of RSS Feeds will likely know that the discontinuing of service by Google Reader caused...
2014-01-24
973 reads
Friday Followup For January 24, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-24
518 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers