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

Archives: April 2016

Interview with Warwick Rudd


Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely… Read more

0 comments, 933 reads

Posted in The SQL Professor on 26 April 2016

Strengthsfinder Results

I recently took the Strengthsfinder evaluation and thought I’d save the results here.

Read more

0 comments, 549 reads

Posted in SQLAndy on 26 April 2016

How to Recover Data From Corrupted Log File In SQL Server ?


SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used on Business platforms for data analysis, data integration and processing components.

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational… Read more

PASS – A Business Case for Attendance

[read this post on Mr. Fox SQL blog]

For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides one of the most fantastic and focused learning and networking experiences available. Read more

0 comments, 2,360 reads

Posted in Mr. Fox SQL on 25 April 2016

Cumulative Updates Every 2 Months

The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a fancy way of saying: Cumulative Updates (CUs) will no longer be shipped when the team feel it’s required, instead a new CU will ship every 2 months.

This scheduled… Read more

0 comments, 477 reads

Posted in The Database Avenger on 25 April 2016

Explicitly using tempdb with ##tables

I had someone ask me last night if this statement would create a permanent table in tempdb with a strange name or a global temp table:

CREATE TABLE tempdb..##mytable
( id int

My suspicion was that this would always be a temp table, but since I usually don’t include… Read more

5 comments, 1,584 reads

Posted in The Voice of the DBA on 25 April 2016

Monday Morning SQL Break – April 25, 2016

It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s time to take a quick break.  For the break, here’s a summary of the most popular links and content that I shared out in the past week through this… Read more

0 comments, 434 reads

Posted in StrateSQL on 25 April 2016

Get your SQL Server MCSA without taking the BI exam.

I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new MCSA (well new 6-8 years ago) we were required to take the data exam (70-461), the admin exam (70-462) AND the BI exam (70-463). I know a number… Read more

2 comments, 1,718 reads

Posted in SQLStudies on 25 April 2016

Partition to Filegroup Mapping in SQL Server

Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a filegroup. It also indicates the next used filegroup if one was specified. Sometimes it is useful to know which partition maps to which filegroup as well as which… Read more

0 comments, 2,355 reads

Posted in Guy Glantser on 25 April 2016

Speaking at SQLSaturday Pensacola

I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there!

If you don’t know what SQL Saturday… Read more

0 comments, 325 reads

Posted in Anthony Nocentino's Blog on 23 April 2016

SQLSaturday Atlanta #521 May 19th & 20th 2016

SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more

0 comments, 553 reads

Posted in The Smiling DBA on 23 April 2016

Colorblind Awareness and Power BI KPIs

Update: The ability to change the color of a KPI was delivered in August 2016!

Color blindness, or color vision deficiency (CVD) affects 1 in 12 men and 1 in 200 women in the world. The chances are good that you have met someone who is colorblind, but you may… Read more

2 comments, 298 reads

Posted in Data Savvy on 23 April 2016

Upcoming Webinars

Next week I am participating in two exciting webinars that I want to share with you!

Improve App Uptime: Tips from MVP David Klee + Customer Case Study with ScaleArc
April 26 – 2:00 PM to 3:00 PM Eastern

Application availability is an “across the stack” problem – straddling the… Read more

0 comments, 450 reads

Posted in Technobabble by Klee from @kleegeek on 22 April 2016

Changing the sa Password with SQLCMD

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

I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more

1 comments, 5,385 reads

Posted in The Voice of the DBA on 22 April 2016

Azure SQL Database pricing

Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size, disaster recovery options, and backup retention days are used to determine pricing instead of hardware (CPU/RAM/HD).  Generally I recommend starting out with a low service tier and scaling as… Read more

1 comments, 1,690 reads

Posted in James Serra's Blog on 22 April 2016

Where Is My Primary Replica Again?

We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas.  One of the problems I have always had with Availability Group management via the GUI (admit it, you use the GUI sometimes all you non-PowerShell geeks) is the fact that most of the…

Read more

2 comments, 2,531 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 April 2016

Power BI Service error: “This visual has unrecognized fields”

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more

4 comments, 1,998 reads

Posted in Koen Verbeeck on 22 April 2016

Setting up powershell remote sessions

Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can remotely connect to powershell sessions using the Server Manager that comes with Windows Remote Administration Tools but it’s a bit of a clicky process and I like to eliminate using… Read more

2 comments, 1,637 reads

Posted in The DBA Who Came In From The Cold on 22 April 2016

How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando

We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40 miles apart, Orlando being the metro sprawl area that it is. Back when we nervously made the decision to launch MagicPASS we also talked through the implications for SQLSaturday and… Read more

0 comments, 484 reads

Posted in SQLAndy on 21 April 2016

Newer posts

Older posts