Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.
This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.
In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.
Just because something works, is it prudent to implement a solution knowing there is a chance this design flaw will be stricken from future revs of SQL Server? It depends.
This article explores aspects of a job that help one feel satisfied at work.
In this article, I will show a procedure to isolate the replication traffic from the public network.
Learn how to scale an Azure SQL Datawarehouse up or down, and how to pause it when not in use.
Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.
This week Steve Jones is asking if you stage your database changes ahead of application changes.
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers