-->
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, 200 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, 236 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, 249 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

1 comments, 182 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, 142 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

2 comments, 191 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, 200 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, 203 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, 426 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, 88 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, 193 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, 223 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,402 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.

CREATE DATABASE CRMDB
(
EDITION = 'BASIC',

MAXSIZE = 2GB
)

SELECT name, snapshot_isolation_state, is_read_committed_snapshot_on
FROM sys.databases
WHERE name = 'CRMDB'

Or you can use this DBCC command.

DBCC useroptions…

Read more

2 comments, 180 reads

Posted in All About SQL on 30 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, 186 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,391 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, 3 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, 214 reads

Posted in The Voice of the DBA on 29 May 2018

Temp Tables in SSIS

Temp tables are very handy when you have the need to store and manipulate an interim result set during ETL or other data processing operations. However, if you use SQL Server Integration Services as your ETL tool, you may find some challenges when trying to work with temp tables in… Read more

8 comments, 215 reads

Posted in Tim Mitchell on 29 May 2018

Query To Retrieve Statistics Data: dm_db_stats_histogram

Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced: dm_db_stats_histogram. We’ve always been able to query the statistics using DBCC SHOW_STATISTICS. However, the output, three different result sets with three different structures, made automating access to statistics information a… Read more

1 comments, 1,825 reads

Posted in The Scary DBA on 29 May 2018

Older posts