SQL Server 2012 (“Denali”): FileTable
FileTable is a new feature in SQL Server 2012 that is built on top of SQL Server FILESTREAM technology, which...
2012-02-22
1,614 reads
James Serra's Blog
Please vote for my SQLRally session
I’m hoping to do a presentation at SQLRally in Dallas on May 10-11, but I need your help!
There is a...
2012-02-21
724 reads
SQL Server 2012 (“Denali”): PowerPivot
Version 2 of PowerPivot (download) is being made available with SQL Server 2012. There are many new features, and my top 5 are:
Diagram...
2012-02-20
1,533 reads
SQL Server 2012 (“Denali”): Microsoft StreamInsight
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,146 reads
SQL Server 2012 (“Denali”): T-SQL Enhancements
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with...
2012-02-15
5,152 reads
SQL Server 2012 (“Denali”): Contained Databases
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure,...
2012-02-15 (first published: 2012-02-13)
2,921 reads
SQL Azure
SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...
2012-02-10
2,430 reads
What is Microsoft Connect?
Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...
2012-02-08
749 reads
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,704 reads
Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,228 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers