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

Archives: January 2016

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.

In this migration process you migrate both your schema and your data from the SQL Server database in your current environment into SQL Database, provided the existing database passes… Read more

2 comments, 719 reads

Posted in James Serra's Blog on 27 January 2016

The Importance of a Full Backup in SQL Server

This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely 100 level, introductory blog posts meant to help people that are just getting started as data professionals. I’ll try to cover several different topics over the year, but felt I… Read more

2 comments, 379 reads

Posted in The Scary DBA on 27 January 2016

The CONNECT permission

The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at the instance level, but prior to that it was just CONNECT. It does basically the same thing in both cases. The CONNECT permission allows you to connect to the associated… Read more

6 comments, 1,457 reads

Posted in SQLStudies on 27 January 2016

Goodness-of-Fit Testing with SQL Server Part 4.2: The Hosmer–Lemeshow Test with Logistic Regression

By Steve Bolton

…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using SQL Server to perform goodness-of-fit testing on regression lines, rather than on probability distributions. These are actually quite simple concepts; any college freshman ought to be able to… Read more

0 comments, 1,225 reads

Posted in Multidimensional Mayhem on 26 January 2016

Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016

Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ If you’re still on SQL Server 2005, there are some important things to be aware of.  First and foremost is that you are missing out on innumerable capabilities in more…

Read more

0 comments, 433 reads

Posted in SQL Server BI Blog on 26 January 2016

Speaking at SQLSaturday Chicago

I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I will be talking about the system_health Extended Events session and the default trace. Here’s the details:

Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

As DBAs,… Read more

0 comments, 318 reads

Posted in The Data Files on 26 January 2016

Microsoft & R Programming Session Materials & Resources Available

Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power BI User Group. We took an introductory look at how Microsoft’s acquisition of Revolution Analytics is making serious waves across the Microsoft data platform. We also walked through leveraging… Read more

2 comments, 795 reads

Posted in SQL with Dustin Ryan on 26 January 2016

Does an index scan always read the entire index?

No.

That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a scan.

A seek is an operation which navigates down the index’s b-tree looking for a row or for the start/end of a range of rows. A seek requires a… Read more

9 comments, 356 reads

Posted in SQL In The Wild on 26 January 2016

Tim Ford’s Entry-Level Content Challenge

All bloggers started as beginners.  We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge.  The problem is that most of us moved on to talking about advanced topics and left people to fend for themselves on the difficult entry-level learning… Read more

0 comments, 442 reads

Posted in Simple SQL Server on 26 January 2016

What is an Identity?

  •         Identity (or AutoNumber) is a column that automatically generates numeric values.
  •          A start and increment value can be set, but most DBA leave these at 1.
  •          A GUID column also generates numbers; the value of this…

Read more

0 comments, 29 reads

Posted in TSQL Circle Live on 26 January 2016

What is Normalization in SQL Server?


In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a database into 2 or more tables and defining relationships between tables. Objective is to isolate data so that additions, deletions, and modifications can be made in just one table. 


Benefits:-…

Read more

0 comments, 54 reads

Posted in TSQL Circle Live on 26 January 2016

What is Power BI?

One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you can’t get a speaker.  I fell into this exact scenario for February’s meeting of Triad SQL.  I was trying to figure out what to present when the planets aligned.… Read more

2 comments, 2,727 reads

Posted in SQL Swimmer on 25 January 2016

Creating a Database Snapshot

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I’ve rarely dealt with database snapshots, outside of lab experimentation. They didn’t exist when I did most of my DBA work, and since then we haven’t seen the… Read more

1 comments, 1,833 reads

Posted in The Voice of the DBA on 25 January 2016

Monday Morning SQL Break – January 25, 2016

It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog.

Most…

Read more

0 comments, 268 reads

Posted in StrateSQL on 25 January 2016

Finding Your Query in Query Store

Query Store is pretty amazing. I’m loving working with it. I think it’s likely to change how query tuning will be done in the future. Lots of people are probably going to just use the reports and tools in SQL Server Management Studio. However, a pretty healthy chunk of us… Read more

2 comments, 1,997 reads

Posted in The Scary DBA on 25 January 2016

From the Power BI dashboard to a specific page in a Report

Recently, I was working with a customer designing Power BI reports and dashboards.  Everything was going great until she asked this question, “Is it possible to set the hyperlink of a tile on a dashboard to go to a specific page on a report?”.  Hmmm, I thought.  Is it possible?… Read more

2 comments, 952 reads

Posted in SQLDownSouth on 25 January 2016

Reusing schedules in SQL Agent

I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor for unexpected problems (because if they are expected you fixed them right?). One common place for us SQL people to do our automation is SQL Agent. It’s built into SQL… Read more

1 comments, 1,337 reads

Posted in SQLStudies on 25 January 2016

Public Speaking – The First Time

This past week I had the pleasure of speaking for my first time professionally to the Chicago Suburban SQL Server User Group. I’ve spoken academically before, but this was my first SQL Server talk. My topic was on Performance Monitoring AlwaysOn Availability Groups. I certainly wanted to put… Read more

2 comments, 374 reads

Posted in Anthony Nocentino's Blog on 25 January 2016

Querying Deadlocks From System_Health XEvent

It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is already capturing this information by default.

This script will, by default, read from system_health.  However, change the name of one parameter at the start to have it read from any… Read more

3 comments, 2,273 reads

Posted in Simple SQL Server on 25 January 2016

Speaking at SQL Saturday #500 in Boston!




I have been selected to speak at SQL Saturday #500 in Boston on March 19th - I will be speaking (at 9am in the morning!) on "Getting Started with Extended Events":

--
Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD)…

Read more

0 comments, 366 reads

Posted in Nebraska SQL from @DBA_ANDY on 25 January 2016

Newer posts

Older posts