Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,209 reads
Simply Dumb Founded - A Non SQL Blog
Blogging is both more fun and harder than it looks, so when someone is getting started I try to offer...
2009-04-20
548 reads
The Death of Email Questions
One of my policies is not to answer questions from people about SQL Server in email. That includes emails to...
2009-04-20
1,060 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,104 reads
So, what book do you recommend?
Another excellent blogger here on SSC, Jeffery Yao, has posted up an interesting idea http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/04/20/database-administration-literature-criticism.aspx .
As a PASS chapter leader...
2009-04-19
465 reads
Networking Results
I've written quite a few posts lately on networking and a very common question is - where's the results? What do...
2009-04-19
982 reads
Database Administration Literature Criticism
What is literature? I find this definition is pretty intuitive at http://classiclit.about.com/od/literaryterms/g/aa_whatisliter.htm and also this one is more comprehensive at...
2009-04-19
1,016 reads
LinkedIn as your Stepping Stone for Opportunities with Internationally-Oriented Organisations
As some of you may have read already, Andy Warren‘s series on LinkedIn (part 1, 2,3) and networking has sparked my...
2009-04-19
1,188 reads
I Need a Backup and I Need It Now
I Need a Backup ... And I Need It Now
Have you ever wished that creating a backup on the fly was...
2009-04-18
3,512 reads
First Foundation Class Review
The first Pragmatic Works Foundation class concluded today and I think it was a great success! Each student did very...
2009-04-17
845 reads
Blogs
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...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
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