2018-09-13
5,040 reads
Articles
How to Linux for SQL Server DBAs — Part 1
As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.
2018-09-13
3,067 reads
Deep dive into Python scripts execution in SQL Server
This article looks at how Microsoft implemented the Python language support into SQL Server and how it can be used.
2018-09-12
2,982 reads
What is the impact of setting SET ANSI_WARNINGS OFF?
Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.
2018-09-11 (first published: 2016-08-23)
29,718 reads
Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data
There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data.
2018-09-11
2,713 reads
Bringing them back from the dead
When trying to find the causes for why the SQL Server service doesn’t start, one of the best places to start is the SQL Server Error log, but there is a problem!
2018-09-10
1,355 reads
Questions About Kerberos and SQL Server That You Were Too Shy to Ask
Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.
2018-09-10
3,437 reads
Configuring Service Broker Architecture
Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.
2018-09-07 (first published: 2015-09-03)
10,803 reads
Foundational Material: Microsoft SQL Server Book and Blogs From The Past
Erik Darling dusts off his favorite archival-quality bloggers and books.
2018-09-07
2,958 reads
Introduction to Testing Your PowerShell Code with Pester
Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.
2018-09-06
2,813 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers