It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
538 reads
Jen McCown
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
920 reads
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,146 reads
Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
518 reads
Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
536 reads
MidnightSQL Server Evaluation script, version 1.0
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,264 reads
Interviews with Great SQL People – Authors, MVPs, many more
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,272 reads
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
523 reads
SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
702 reads
#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
525 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers