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

Archives: July 2017

Speaking at SQL Saturday Denver (#673)

Wow, I can hardly contain my excitement.  I was selected to speak at SQL Saturday Denver on September 16, 2017.  I’ll be presenting my Intro to Integration Services session.  I’m excited for so many reasons, but firstly, this will be my first trip back “home” in seven years.  We planned…

Read more

0 comments, 166 reads

Posted in SQL Swimmer on 28 July 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

10 comments, 2,287 reads

Posted in SQL with Dustin Ryan on 28 July 2017

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players… Read more

2 comments, 39 reads

Posted in SQL with Dustin Ryan on 28 July 2017

Information Measurement with SQL Server, Part 1: A Quick Review of the Hartley Function

By Steve Bolton

…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A Rickety Stairway to SQL Server Data Mining series, which made it clear to me that I didn’t know enough about what was going on under the hood in… Read more

0 comments, 228 reads

Posted in Multidimensional Mayhem on 28 July 2017

Using Test-DbaOptimizeForAdHoc

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions.

One of the cmdlets is Dba-OptimizeForadHoc, which is designed to help you determine if this… Read more

0 comments, 274 reads

Posted in The Voice of the DBA on 28 July 2017

Friday Reading 2017-07-28

Hope you all had a good week. Been pretty chilled out here so I’ve been reading…

Announcing Azure Container Instances
Microsoft blog about a new Azure service allowing us to deploy containers from the Azure CLI

sp_WhoIsActive Documentation
All of the supporting docs for Adam Machanic’s excellent sp_WhoIsActive

13 things… Read more

0 comments, 259 reads

Posted in The DBA Who Came In From The Cold on 28 July 2017

“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands

On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the Microsoft PowerShell module ReportingServicesTools to automate several steps that otherwise would be a big time consumer.
 
After a couple of shares and re-tweets, my friend Rob… Read more

10 comments, 2,001 reads

Posted in Cláudio Silva on 27 July 2017

SQL Server on Linux Series: Moving TempDB

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out our storage workload. Let’s move the tempdb objects to one of these new drives!

By default, our tempdb files are in the system database folder at /var/opt/mssql/data.

We previously created… Read more

1 comments, 1,129 reads

Posted in Technobabble by Klee from @kleegeek on 27 July 2017

Two Ways to Restore Database from MDF File in SQL Server

Introduction

In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best and successful RDBMS which provides highly integrated services to manipulate the SQL database over the Server. As we talk about… Read more

4 comments, 3,150 reads

Posted in Vivek's SQL Notes on 27 July 2017

Azure Labs–Minor Cluster Issues for SQL Server Setup

During the process of building an Azure lab, I ran into a place where my cluster was not completely validated. I think this happened when a node failed and was re-provisioned, but in any case, when I ran SQL Server setup, the program failed cluster validation and would not install. Read more

0 comments, 295 reads

Posted in The Voice of the DBA on 27 July 2017

DevOPs is not just about the latest & greatest tools

I’m a technical guy.

Thus – I love tools. They make stuff go.

Tools are great.

Except – as I wrote in my other post — DevOPs and Databases — the one thing you may be doing wrong.  You can’t just focus on one thing in DevOPs.

You need to… Read more

0 comments, 1,502 reads

Posted in The Hybrid DBA's Blog on 26 July 2017

Working with Very Large Tables

 

Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”. The session was hosted in the PASS Database Administration Virtual Group. You might be surprised, but I was talking about how to work with very large tables… Read more

0 comments, 2,846 reads

Posted in Guy Glantser on 26 July 2017

Acids and Databases: A look at ACID and transactions

Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to select, insert, update, and delete data without affecting everyone else. An RDBMS is considered ACID-compliant if it can guarantee data integrity during transactions under the following conditions: ACID Atomic –… Read more

0 comments, 44 reads

Posted in Born SQL with Randolph West on 26 July 2017

Happy Belated 150th Birthday Canada, and the Importance of Compliance, Especially Vulnerability Assessments

Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's Meadow on Blackcomb, May, 2017 (luckily nobody was on the mountain at 4am).

About ten years ago, I was all keen to speak publicly about controlled environments, and the importance…

Read more

0 comments, 448 reads

Posted in The Database Hive for SQL Server DBAs on 26 July 2017

DevOps–Fixing Poorly Named Constraints

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement.

ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC]

The problem was that this was the constraint on one developer’s workstation, but on… Read more

2 comments, 1,557 reads

Posted in The Voice of the DBA on 26 July 2017

Performance is bad. Did you change anything recently? No. Are you sure?

Ever have this conversation?

Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA: Sure thing. Has any code changed recently?
Dev: No. Nothing’s changed at all. Everything is just suddenly slower.
DBA: Are you sure?

Want to bet some code has… Read more

3 comments, 2,886 reads

Posted in SQLStudies on 26 July 2017

Speaking at TechMentor – Redmond

I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides you with in-depth, immediately usable training that will keep you relevant in the workforce. 

I’ll be presenting the following session: Workshop: Linux OS Fundamentals for the Windows Admin – this… Read more

0 comments, 175 reads

Posted in Anthony Nocentino's Blog on 26 July 2017

Automatically restarting Docker containers

One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that the host machine is now a single point of failure.

Now there’s a whole bunch of posts I could write about this but the one point I want to bring… Read more

0 comments, 1,275 reads

Posted in The DBA Who Came In From The Cold on 26 July 2017

Power BI Custom Visuals Class (Module 61 – Power KPI)

In this module you will learn how to use the Power KPI Custom Visual.  The Power KPI displays your KPI indicator values on a helpful multi-line chart with labels.

Module 61 – Power KPI

Downloads

Read more

1 comments, 1,652 reads

Posted in Devin Knight on 25 July 2017

SSoL: Where are my data and log files?

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university. Read more

0 comments, 437 reads

Posted in The Voice of the DBA on 25 July 2017

Newer posts

Older posts