SQL Server: Discuss Execute(SQL) At LinkedServer
Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...
2016-11-09
1,837 reads
Blog Posts
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,728 reads
The ROI of SQLSaturday
Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday....
2016-11-09
479 reads
This Week In Data – Episode 12 (How to Interview a Customer)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-09
421 reads
A Good Deed After Game Night
When we set up Game Night, we decided to sell tickets to reduce our risk. However, we didn’t have a...
2016-11-08
569 reads
Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
465 reads
Growing Speakers for T-SQL Tuesday #84
It’s T-SQL Tuesday again, and for $#84, we have a non-technical topic. Hopefully this will then let us produce more...
2016-11-08
596 reads
Login from an Untrusted Domain – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-11-08
519 reads
Login from an Untrusted Domain – Back to Basics
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Related Posts:
Summiting that Technical Challenge January 9, 2018
Connect To SQL Server - Back...
2016-11-08
13 reads
Notes from the 2016 SQLSaturday Roundtable Meeting
Each year PASS holds a meeting for SQLSaturday event leaders and key players on Tuesday morning. It’s a valuable meeting,...
2016-11-08
474 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