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,121 reads
James Serra's Blog
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,621 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,218 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
800 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,466 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works. There were over 500 attendees! The abstract...
2013-06-14
1,277 reads
Levels in IT consultancy
The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...
2013-06-13
1,061 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Thursday, June 13th at 11:00am EST for Pragmatic Works. Below is...
2013-06-12
932 reads
Business Intelligence Maturity Assessment
Do you ever wonder how your business intelligence (BI) and data warehousing (DW) environment compares to other companies and what...
2013-06-11
4,160 reads
IT recruiter’s response
I asked a recruiter to check out my blogs about consulting, and his response is below. He had some good...
2013-06-06
891 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers