A first look at SQL Server 2016–String_split
I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...
2016-03-13
621 reads
Goodness-of-Fit Testing with SQL Server Part 6.2: The Ryan-Joiner Test
By Steve Bolton
…………In the last installment of this amateur series of self-tutorials, we saw how the Shapiro-Wilk Test might probably...
2016-03-12
851 reads
SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
75 reads
SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
2,383 reads
The Virginia Tour 2016
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
3 reads
The Virginia Tour 2016
Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...
2016-03-11
519 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....
2016-03-11
7 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which...
2016-03-11
440 reads
Finding Strings
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-11
690 reads
Download Attachments from Exchange Web Services using SSIS
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
334 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers