Adding User Comments to Reports in SQL Server Reporting Services
In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.
2018-09-21
2,383 reads
Additional Articles
2018-09-21
1,949 reads
Advanced Testing of Your PowerShell Code with Pester
Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.
2018-09-20
2,439 reads
Azure SQL Database High Availability
Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.
2018-09-18
2,171 reads
Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters
In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.
2018-09-17
4,254 reads
Single-Column-Key Missing Index Recommendations are Usually Wrong.
When Clippy suggests an index with only one key, look closer.
2018-09-14
2,975 reads
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
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
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
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers