Knut Jürgensen shares his experiences, both positive and negative, with regard to the function that Master Data Management fulfils within a company. Too often this critical aspect of a business is overlooked or pushed aside without paying it the attention it deserves based on the cost benefits available.
2016-06-16
4,935 reads
In the third part of his series on Row Level Security (RLS), Greg Larson shows how to disable RLS for database administrators, sysadmins, and database owners.
2016-06-15
6,385 reads
Paul White discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.
2016-06-14
3,877 reads
The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of working with SQL Server. The most suitable approach to accessing SQL Server depends on the sort of task you need to produce a script for. Laerte Junior aims at a simple guide to the most common approaches and when to use them.
2016-06-14
3,826 reads
Automated configuration management is simpler with Desired State Configuration (DSC) and Push mode, but what is the best way to use DSC to automate deployments on your machines? ‘Push’ mode or ‘Pull’ mode? How can you reduce configuration-drift over time? Nicolas Prigent describes the second DSC deployment mode: Pull mode.
2016-06-13
3,500 reads
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index.
2016-06-10
4,346 reads
Aaron Bertrand rounds out his series on STRING_SPLIT() in SQL Server 2016 with additional tests comparing splitting techniques to TVPs.
2016-06-09
4,804 reads
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.
2016-06-08
2,497 reads
Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.
2016-06-07
6,986 reads
Karthik provides a simple solution to querying a table that has comma separated values.
2016-06-06
8,568 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers