(Stephanie Herr) The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least preparing for, all the processes and tasks that are necessary for deployment as soon as possible in the develo
Tag: sql server
(Michael Otey) Flash storage adoption, cloud computing’s growth, Linux’s increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.
(Eli Leiba) You need a simple tool to detect any SQL Server configuration values that have been changed from their default value. This task is common when investigating SQL Server performance problems.
SQL Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
(Manoj Pandey) I was trying to export a SQL table to Excel and I got below error:
(Thomas LaRock) Last week at SQL Live I gave a talk “Configuring SQL Server like a Microsoft Certified Master”. It’s a session Tim Chapman (blog | @chapmandew) and I built previously and I’ve made an effort to keep updated.
(Pinal Dave) One of my clients reported a usual behavior of the AlwaysOn availability group. He informed me that he is trying to add a login on the secondary replica in the AlwaysOn AG environment but it is failing with below error:
(Greg Larsen) If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement.
(Patrick El-Azem) Dynamic Data Masking (DDM) is a new security feature in Microsoft SQL Server 2016 and Azure SQL DB. The main documentation is here (also see link under Resources at end).
(Rajendra Gupta) In my previous tip SQL Server 2016 Management Studio Enhancements we have seen some of the new SQL Server Management Studio (SSMS) features and improvements. In this tip we will explore some more enhancements in SSMS.
(Pinal Dave) After seeing various issues with SQL Server startup problem, I felt that I know almost most of the errors, but I was wrong till someone contacted me with a new error.