Driving up Database Coding Standards and Productivity with SQL Prompt
Alongside specialists, an IT department needs people who are broadly skilled and adaptable, who can pivot quickly to new projects, slot easily into new teams, and be productive quickly. In this blog post, we will learn about database coding standards a …
24 Hours of PASS (June 2018) – Summit Preview
Which topics can you expect to see at the PASS Summit 2018? Find it out from June 12 to 13, 2018 at the 24 Hours of PASS – Summit 2018 Preview – edition.Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented …
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
My lab machine is my playground. Other than my real-world client’s problem, many blogs have come from my lab machine because I keep on breaking something or another on my server. Once I found that I was unable to start SQL Server Agent service fo …
[Video] Office Hours 2018/5/30 (With Transcriptions)
This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move databases from SQL 2008 R2 to SQL Server 2014, adding Analysis services to a cluster, taking to higher management, deadlocks in a transaction log shipping setup …
SQL SERVER – All the Features not Listed While Installing SQL Server
I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Se …
Mysterious Forwarded Records
Thinking Of You When people think about Heaps and the problems they can cause, they don’t often think of temp tables and table variables as Heaps. Of course, without a clustered index, any table is a Heap. This isn’t an argument for or agai …
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
In my lab environment, I was testing a script to change service account and it worked fine. I had Always On configured on this SQL Server and soon I realized that after changing the SQL Server service account, the secondary replica went into a disconne …
Wanna Attend All My Classes for a Year?
Live Class Season Pass When I introduced my Live Class Season Pass, buyers got access to my entire new Mastering series for 2018. I wasn’t sure how buyers would react to the new class lineup – these classes are tough. They’re 3 d …
Automating a SQL Server Database Refresh
In this tip we cover the basics of what needs to be done to setup a process to automate refreshing a dev or test environment with a recent database backup.
Using SQL Data Compare to Synchronize Custom Error Messages
In this recent Redgate article Steve Jones provides a useful trick to Synchronize Custom Error Messages using SQL Data Compare
Solving the Target Principal Name is Incorrect
One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Question: How to Enable Files & Folders Level Auditing in SQL Server? Answer: Recently I was working with a client on a SQL startup issue. After spending a lot of time, we were able to find that many files were missing in Binn folder. Now, the …
How Many Kinds Of Joins Are There?
Quite So There are three in SQL Server, not counting the Adaptive Join which is just a placeholder for either Nested Loops or Hash Joins. If you look closely at each of those joins, you’ll see all sorts of interesting things pop up. Hopefully non …
PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard
Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. …
Free eBook: Defensive Database Programming
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of un …