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

Archives: May 2018

Single User Mode – Back to Basics

In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain sysadmin access. In that article, I made quick mention of restarting SQL Server into single-user mode. It only makes sense to show quickly how to get into single-user mode. Read more

5 comments, 433 reads

Posted in SQL RNNR on 31 May 2018

Power BI Data Security – Power BI Report Server

Power BI Report Server was released as a way to host reports on premises. It was one of the highest requested features for Power BI. Power BI Report Server offers a subset of Power BI Service capabilities and as such does not have the rich collaborative or security options as… Read more

1 comments, 440 reads

Posted in DataOnWheels on 31 May 2018

Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger

It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is documented in Books Online.

When I first started playing with this version, I noticed that SQL Agent was disabled. That’s not great, since SQL Agent is a great tool for… Read more

1 comments, 416 reads

Posted in The Voice of the DBA on 31 May 2018

Updated query to view data in the error log

This is one of my favorite scripts. It pulls all of the data from the error log and dumps it into a temp table. I did one version here but it was pretty specific to I/O errors. I also gave some homework to find/build a script like it. So if… Read more

2 comments, 314 reads

Posted in SQLStudies on 31 May 2018

SQL Saturday 769 Melbourne & 771 Sydney

For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney

  • SQL Saturday 769 (Sat 30 Jun 2018) Melbourne.  SQL Saturday 771 (Sat 07 Jul 2017) Sydney.  For those looking for some great free local SQL / Azure /…

Read more

0 comments, 301 reads

Posted in Mr. Fox SQL on 31 May 2018

Lost that SQL Server Access?

As a data professional can you recall the last time you needed to support a SQL Server instance for which you had no access? What if you used to have access and then that access magically disappeared?

I know I run into this dilemma more than I would probably like… Read more

3 comments, 403 reads

Posted in SQL RNNR on 30 May 2018

The Importance of ORDER BY

Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if they want the results ordered. Otherwise the order in which they are returned is not guaranteed.

But then you run queries a lot of times that don’t need a specific… Read more

1 comments, 357 reads

Posted in Matthew McGiffen DBA on 30 May 2018

Backup and Restore Automation using SQLCMD and SQL Server agent

Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to the test or development environment. This is done so that the development or the test environment closely resembles the production … Continue reading

Read more

0 comments, 357 reads

Posted in PowerSQL By Prashanth Jayaram on 30 May 2018

Getting value out of data quickly

There are times when you need to create a “quick and dirty” solution to build a report.  This blog will show you one way of using a few Azure products to accomplish that.  This should not be viewed as a replacement for a data warehouse but rather as a way… Read more

2 comments, 699 reads

Posted in James Serra's Blog on 30 May 2018

Getting value out of data quickly

There are times when you need to create a “quick and dirty” solution to build a report.  This blog will show you one way of using a few Azure products to accomplish that.  This should not be viewed as a replacement for a data warehouse but rather as a way… Read more

2 comments, 311 reads

Posted in James Serra's Blog on 30 May 2018

Dates and Times in SQL Server: the problem with DATETIME

Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have disagreed with, namely that DATETIME is a terrible data type which you should not be using in new development. The motivation for this position is… Read more

1 comments, 322 reads

Posted in Born SQL with Randolph West on 30 May 2018

Importance of Statistics

Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and play a part in execution plans. The cardinality estimator relies heavily on statistics to get the answer to selectivity (the ratio of distinct values to the total number of values)… Read more

1 comments, 496 reads

Posted in SQLEspresso on 30 May 2018

An interview with Brent Ozar

I was talking about interviews (although not the job kind) with a friend and it reminded me of the time I did an email interview with Thomas LaRock (b/t) and then one that I did for someone else. This got me thinking it would be… Read more

5 comments, 2,755 reads

Posted in SQLStudies on 30 May 2018

Azure SQL Database – The Default Isolation Is?

So what is the default isolation level for Azure SQL Database? I ran the following code to check it out. Or you can use this DBCC command. Quite simply the default isolation level for Azure SQL Database is RCSI – … Continue reading

Read more

2 comments, 352 reads

Posted in All About SQL on 30 May 2018

SQL Server Minimally Logged Inserts (Assume Nothing!)

Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging copying data from one table to another in SQL Server. I’m running SQL Server 2017 CU7 and it quickly turned out that I couldn’t get minimal logging to happen…

Read more

0 comments, 82 reads

Posted in Gavin Draper's SQL Server Blog on 29 May 2018

SQL Server Minimally Logged Inserts (Assume Nothing!)

Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging copying data from one table to another in SQL Server. I’m running SQL Server 2017 CU7 and it quickly turned out that I couldn’t get minimal logging to happen…

Read more

0 comments, 84 reads

Posted in Gavin Draper's SQL Server Blog on 29 May 2018

SQL Server: Backup and Restore operations using Cloud

This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob storage service as a target for the backup. As we all know, disk and tapes were the default destinations of … Continue reading

Read more

0 comments, 331 reads

Posted in PowerSQL By Prashanth Jayaram on 29 May 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

Problem

My company heavily uses MSX/TSX jobs for everything.  But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same time.  So here is a quick little post on how you can schedule the workload to spread out across all your… Read more

2 comments, 1,574 reads

Posted in Database Superhero’s Blog on 29 May 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

Problem

My company heavily uses MSX/TSX jobs for everything.  But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same time.  So here is a quick little post on how you can schedule the workload to spread out across all your… Read more

2 comments, 118 reads

Posted in Database Superhero’s Blog on 29 May 2018

Cleaning up Azure Client IPs

I travel around, and as a result, I may find myself accessing my Azure databases from different locations. Since it’s a quick click and login to add my IP from SSMS, I’ll end up with multiple ones. I don’t want to leave systems open for a long time, and certainly… Read more

0 comments, 364 reads

Posted in The Voice of the DBA on 29 May 2018

Older posts