-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Power BI Report Accessibility Checklist

In many cases, some small changes can go a long way in making your Power BI reports more accessible for users with different abilities. The checklist below lists considerations you should make in your report design to create more inclusive reports. I’ll update this post as new features are released. Read more

2 comments, 601 reads

Posted in Data Savvy on 7 June 2018

Cycle Through Your Clipboard History In SSMS

This is my favourite SSMS trick I’ve discovered recently, probably some time towards the end of last year.

Basically, when you paste in Management Studio, you have not just the option to paste the last thing you selected and copied, but can cycle back through previous things that were in… Read more

1 comments, 989 reads

Posted in Matthew McGiffen DBA on 6 June 2018

Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition

Occassionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example:

The instructions usually require using Group Policy Editor (gpedit.msc). Unfortunately, I am using Microsoft Windows 10… Read more

1 comments, 377 reads

Posted in SQL Quantum Leap on 6 June 2018

The June 2018 SQL in the City is coming

We’ve got the schedule up and you can register today. Once again I’m heading to the UK, along with Grant, to broadcast a series of sessions that we hope will help you learn a bit more about building better database software and protecting data.  Kathi’s recording her session as… Read more

0 comments, 530 reads

Posted in The Voice of the DBA on 6 June 2018

Generate RESTORE LOG statements

Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.

The post Generate RESTORE LOG statements appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 587 reads

Posted in SQL Awesomesauce on 6 June 2018

T-SQL aside: replace PRINT with RAISERROR

I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even learned something that had always bothered me but had been too lazy to investigate further. Tip #4: Know Your Place Don’t be afraid to use… Read more

2 comments, 852 reads

Posted in Born SQL with Randolph West on 6 June 2018

Getting Called Up

When baseball players are called up to the Major League from the Minor League it’s referred to as getting “Called Up”.  Today I am proud (and very humbled) to announce that I have been Called Up to PASS Summit 2018.  I will be presenting my Data Types Do Matter Read more

4 comments, 142 reads

Posted in SQL Swimmer on 6 June 2018

Speaking at PASS Summit 2018

I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November. I will be presenting a half-day talk entitled Build a Metadata-Driven ETL Repository with Biml and SSIS: Your boss tells you that a new field will be added to one… Read more

4 comments, 143 reads

Posted in Tim Mitchell on 6 June 2018

What queries are getting blocked?

Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how the system health extended event session pulls, among other things, queries that have to wait for more than 30 seconds for a resource. He shows us… Read more

0 comments, 2,201 reads

Posted in SQLStudies on 6 June 2018

Understanding the Role of SQL Server Agent in SQL Server

SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service and starts automatically when the system boots. It basically performs the backup task, handles reporting services, log shipping, and user tasks…

Read more

0 comments, 289 reads

Posted in SQL Server Overview on 6 June 2018

Speaking at PASS Summit 2018!

I found out a few days ago that one of my sessions was selected for Summit this Fall - I will be presenting an updated version of my "Getting Started with Extended Events" session that I have been working at SQL Saturdays over the last couple years.

I…

Read more

0 comments, 122 reads

Posted in Nebraska SQL from @DBA_ANDY on 6 June 2018

Power BI Monthly Digest – June 2018

This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of our favorite Power BI updates each month. In our June 2018 edition we highlighted the following features:

  • Format data labels differently in Combo Charts
  • Adjusting Donut Chart…

Read more

0 comments, 1,336 reads

Posted in Devin Knight on 6 June 2018

Resend an email sent from SQL Server using TSQL

Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn’t always matter as the job that generated the email can simply be re ran to produce the email once again, but what about those emails that contain time specific information?… Read more

3 comments, 1,715 reads

Posted in SQL Undercover on 5 June 2018

Does a Query always wait in the SUSPENDED State?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about a very interesting topic: in which execution state… Read more

0 comments, 570 reads

Posted in Klaus Aschenbrenner on 5 June 2018

Music City Tech Rocked!

I know Nashville is most famous for Country music, but in the recent years, it has become home to more and more genres.  Last week I attended and spoke at Music City Tech/Music City Data in Nashville and let me tell you, it ROCKED!  The organizers were amazing, all the… Read more

0 comments, 120 reads

Posted in SQL Swimmer on 5 June 2018

Did you know…you can change the default file encoding for new query on SSMS?

If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules (Stored Procedures, functions, etc) and the steps I'm following (roughly speaking) for converting are: Open new query… Read more

0 comments, 209 reads

Posted in Cláudio Silva on 5 June 2018

Prepping for Mastering Index Tuning with Brent Ozar Unlimited

I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it. I struggle to find time for training, between work commitments, travel, and family time, it’s hard to fit in a day or two. I’ve almost given up on going to… Read more

4 comments, 1,905 reads

Posted in The Voice of the DBA on 5 June 2018

WSFC Lost Quorum votes due to network problem



Problem:

Early in the morning I received emails requesting for support as the applications were failing to connect to one of the production servers that are configured with Always On, I asked for an specific error and the customer sent me this:

---------------------------
Error while updating the backup server list:…

Read more

0 comments, 1,622 reads

Posted in SQLDbaInternals on 5 June 2018

Linked Server to Azure SQL Database

You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally installed SQL Server. One reason could be to pull down some reports from an Azure SQL Database to a local file share. Whatever your reason is hopefully you will find… Read more

2 comments, 1,554 reads

Posted in All About SQL on 5 June 2018

Bring Your Own Key to Azure SQL Database TDE New UI

In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your own key was through PowerShell and T-SQL. Thankfully, that has changed. A recent update added a UI for managing your… Read more

0 comments, 1,460 reads

Posted in Bradley Schacht on 5 June 2018

Newer posts

Older posts