SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton
What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...
2013-07-23
2,057 reads
James Serra's Blog
Why You Need a Data Warehouse
Introduction
You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....
2013-07-25 (first published: 2013-07-18)
5,976 reads
The benefit of placement firms
Why do companies use placement firms to find IT contractors instead of using internal recruiters?
Who better to answer that question...
2013-07-16
785 reads
I’ll take “Products that start with Power”, Alex
FYI:
Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called...
2013-07-11
883 reads
Power BI for Office 365
Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365:
Power BI for Office 365 is a cloud-based business intelligence...
2013-07-09
1,502 reads
SQL Server Data Tools (SSDT) – June 2013 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...
2013-07-02
2,114 reads
Visual Studio 2013 preview available
Wow, Visual Studio 2012 is just out of diapers and here comes the next version!
Microsoft officials released the preview of...
2013-06-27
1,612 reads
SQL Server 2014 CTP1 is here!
As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...
2013-06-25
1,210 reads
TechEd North America 2013 videos online
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
795 reads
Low-rate recruiters – The bane of my existence
There is nothing more annoying to me in my profession than getting calls and emails from recruiters who are looking...
2013-06-18
1,460 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers