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 have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Comments posted to this topic are about the item A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers