Friday Reading 2017-03-31
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
573 reads
Looking Back at the SQL Clone Launch(es)
Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along...
2017-03-30
1,045 reads
Applying SQL Service Pack on Encrypted Drives
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
708 reads
Your physical memory configuration can slow down your servers
Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on...
2017-03-30
716 reads
Power BI Custom Visuals Class (Module 44 – Attribute Slicer)
In this module you will learn how to use the Attribute Slicer Power BI Custom Visual. Using the Attribute Slicer...
2017-03-29
1,157 reads
Trouble Shooting Little Jewel
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
708 reads
Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,003 reads
A First Look At Normalization
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
320 reads
Microsoft database migration tools
There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17):
Data Migration Assistant (DMA)...
2017-03-29
1,124 reads
Random Blogging Challenge Results
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
649 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