50 online SQL Server training courses and a free trial
With the publication of our most recent Pluralsight course last month, we now have a whopping 50 online training courses available through Pluralsight, totally more than 150 hours of content. If you’re unable to come to one of our in-person Immer …
In the Cloud: Visual Studio 2017
Visual Studio 2017 has new functionality to help you build apps for both on-premise and cloud solutions. The screen capture of the Visual Studio 2017 Enterprise installer shows a different interface than the previous several versions of Visual Studio h …
DatabaseRestore: Open Source Database Restore Stored Procedure
Welcome to the DatabaseRestore documentation page. We were looking for a script that restores a database including the transaction log chain using the backup files in a folder. We also wanted it to be able to continue applying transaction log backups. …
New syntax in DAX: IN operator, table and row constructors #dax #powerbi
I recently wrote an article to described in more details the syntax of the IN operator in DAX, which is available in Power BI and in the CTP of the next release of Analysis Services. Jeffrey Wang wrote a blog post about the IN operator a few month …
Detective Stories – Tracking Down the Database’s Dependents Part 2
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
SQL SERVER – Installation Error – The Specified Driver is Invalid
In this blog post we are going to learn about Installation Error – The Specified Driver is Invalid. SYMPTOMS SQL Server installation failed with errors in setup logs. Summary.txt shows below Troubleshooting information for those features: Ne …
Use Amazon’s Alexa to Create a Copy of a Database Using Redgate SQL Clone…
…and win an Amazon Echo Dot and one lucky winner will score a free SQL Clone license! About SQL Clone I can hear you thinking, “What’s SQL Clone, Andy?” I’m glad you asked! SQL Clone is a database provisioning tool that r …
Project Bletchley – The Microsoft Vision for Blockchain
The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March
Finding the Worst Performing TSQL Statement
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
Detective Stories – Tracking Down the Database’s Dependents Part I
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration for SQL is Inaccessible or Invalid
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not able to start SQL Browser service. When we try to start from services, we get below standard error, which is not very helpful. Let us fix the error re …
Why PFS pages cannot be repaired
Last week there was a short discussion on Twitter about why PFS pages can’t be repaired (prompted by a #sqlhelp question about why they can’t be single-page restored, like other per-database allocation bitmaps). PFS pages occur every 8088 p …
Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112
Question: Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? Answer: You might have heard this advice many times but never got a complete answer to “Why”? Most of the blog would tell you “how …
SQL SERVER – How to Apply Patch in AlwaysOn Availability Group Configuration?
This is one of the common question which is asked via emails to me. “How to apply the patch in AlwaysOn Availability Group configuration?” OR “What are the steps we should do and things to take care while patching availability replica …
4 Free Things to Do with a Slow SQL Server
Step 1. Run sp_Blitz and look for urgent warnings. sp_Blitz is one of the free scripts in our First Responder Kit. Just open the sp_Blitz.sql, run that to create the stored procedure, and type: sp_Blitz It returns a prioritized list of things …