Need to output CSV, TSV, or other?
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
409 reads
Daniel Janik
How to display more text in SSMS
Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...
2017-07-28 (first published: 2017-07-14)
11,759 reads
Off Topic: Dream Car Garage: 6 Cars, $250k
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
251 reads
Reading the log on SQL for Linux
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...
2017-06-29
894 reads
1 year of blogging
It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be...
2017-06-22
428 reads
If Clippy found his way to SSMS
Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how...
2017-06-16 (first published: 2017-06-01)
2,733 reads
Access to SQL Server is finally coming
Imagine a world where one of the software giants releases their brand new operating system and a new application architecture...
2017-06-09
1,584 reads
Time saving trick for PowerShell and CMD
Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you...
2017-06-08
532 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
577 reads
DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...
2017-05-09 (first published: 2017-04-27)
3,103 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers