Gethyn Ellis:My SQL Server You Tube Channel
Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...
2017-04-10
320 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
176 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
299 reads
Missing index with create statements
Missing index :- Scripts will help you to get all the missing index and prepare script for new index.
/*
Description:- This Query...
2017-04-10
662 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage of using a separate network for replication is reduced...
2017-04-10
11 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage...
2017-04-10
887 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2017-04-09
12 reads
New Pluralsight Course – LFCE: Network and Host Security
My new course “LFCE: Network and Host Security” in now available on Pluralsight here! If you want to learn about the course, check...
2017-04-09
540 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
12 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
34 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