Flexible connections and an old friend
TweetG’day,
Just lately I’ve found myself involved with an app that needed to run on a server and nearly always (although...
2017-11-26
447 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
9 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
182 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy...
2017-11-25
683 reads
SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...
2017-11-25
606 reads
How to check advanced options in SQL Server?
To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...
2017-11-24
45,436 reads
Hardware Wrestling
A few weeks back I had some issues. They were related to this:
My standing desk was down and as you...
2017-11-24
472 reads
Time Zones are a Drag … Seriously
Time Zones were definitely being a drag today. I got an email from one of the developers at work asking...
2017-11-24
1,103 reads
SSIS Issues : A Day of Learning
Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.
Thanks to...
2017-11-24
484 reads
Azure data centers and Regions: How to pick a best azure region.
Azure data centers and Regions:
Azure data centers are located worldwide and a team/division MCIO (Microsoft Cloud Infrastructure and Operations) manages all the data centers...
2017-12-06 (first published: 2017-11-24)
1,755 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