Tracking Lookup Operations in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-05-22
248 reads
Fischer’s Exact Test – with T-SQL and R
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,480 reads
Monday Coffee 2017-05-22
I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen...
2017-05-22
496 reads
Introduction To SQL Server Statistics
SQL Server statistics are often thought of as a bit of a black box, this is completely not the case...
2017-05-22
132 reads
Dump Data From SQL 2005 table to Excel 2016
By First looking at the topic name, does the task sound simple to you? Well, I thought so but it...
2017-06-01 (first published: 2017-05-22)
1,436 reads
I Finally Get Cross Apply!
For years I’ve looked at various queries online in sample code, diagnostic queries using DMVs, and the like and seen CROSS APPLY in the FROM clauses. But I’ve never...
2017-05-22
8 reads
Learning – Webcasts/Video
Learning for this week. http://www.pass.org/24hours/2017/security/Schedule.aspxhttp://sqlblog.com/blogs/damian_widera/archive/2017/04/20/sql-server-2017-all-sessions-from-microsoft-data-amp-are-online-complete-list-of-links.aspx http://sqlblog.com/blogs/davide_mauri/archive/2017/05/01/pass-appdev-recording-building-rest-api-with-sql-server-using-json-functions.aspx http://sqlblog.com/blogs/sergio_govoni/archive/2017/04/15/pass-business-analytics-marathon-march-2017-recordings-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/31/the-recording-for-biml-in-the-enterprise-data-integration-lifecycle-is-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/14/the-recording-for-the-ssis-catalog-compare-version-2-launch-event-is-available.aspx Free Microsoft books: https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/
2017-05-21
364 reads
Azure CosmosDB SQL Server
As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External...
2017-05-21
436 reads
Power BI Architecture Diagram v3 is Now Available!
Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power...
2017-05-19
201 reads
Power BI Architecture Diagram v3 is Now Available!
Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power...
2017-05-19
1,850 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers