Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it...
2017-04-06 (first published: 2017-03-22)
1,861 reads
Fundamentals of Data Types
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...
2017-03-22
110 reads
Delete an Azure SQL Database from PowerShell
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-04-06 (first published: 2017-03-22)
2,750 reads
Automating DBCC DBTABLE – obtaining the disk Sector Size
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of...
2017-04-04 (first published: 2017-03-22)
10,236 reads
Taking dbatools Test-DbaLastBackup a little further
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...
2017-04-05 (first published: 2017-03-22)
1,929 reads
Creating a list of random numbers
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,330 reads
New SSMS bug?
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
632 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April...
2017-03-22
5 reads
Speaking at PowerShell Summit!
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit...
2017-03-22
328 reads
SQL Saturday Richmond (#610)
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in...
2017-03-22
335 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