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

Latest Blog Posts

Using docker named volumes to persist databases in SQL Server

I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one named volume and I had to manually reattach the databases after the container spun up.

This isn’t really ideal, what we’d want is for the databases to automatically be attached… Read more

0 comments, 92 reads

Posted in The DBA Who Came In From The Cold on 21 March 2019

Power BI Now Has Keyboard Accessible Visual Interactions

The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural strengths is that you can click on a data point within a visual and have it cross-highlight or cross-filter the other visuals on a page. But keyboard-only users weren’t able… Read more

0 comments, 85 reads

Posted in Data Savvy on 21 March 2019

Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal

Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the capabilities like multi factor authentication, self-service password reset, role based access control, security monitoring, managing alerts etc. When user create an Azure AD directory it automatically links with Azure subscription.…

Read more

0 comments, 151 reads

Posted in Kapil Blogs on 21 March 2019

Uppercase All String Columns (and in a Single Query!)

(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )

Intro

The other day, Steve Jones published a short post with a quick script to uppercase all string data in a database. I noticed that a few improvements could be made, so I thought I would give it… Read more

0 comments, 102 reads

Posted in SQL Quantum Leap on 20 March 2019

Two Weeks to #sqlinthecity Streamed

It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel to the UK and join Kendra, Grant, Kathi, and fellow Redgaters for a few hours of training and learning. We’ll be broadcasting live from the Redgate office, and I hope… Read more

0 comments, 121 reads

Posted in The Voice of the DBA on 20 March 2019

Delete activity in Azure Data Factory - Cleaning up your data files

(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that once I learn enough about sourcing data systems and target destination platform, I'm ready to design and build a data integration solution between two or more connecting points.…

Read more

0 comments, 153 reads

Posted in Data Adventures on 20 March 2019

Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell

The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature that opens new possibilities, especially for presentations and for troubleshooting scenarios.

For presentations, it is fairly obvious what the use case is: you can prepare notebooks to show in your… Read more

1 comments, 87 reads

Posted in SpaghettiDBA on 20 March 2019

The free SQL to Excel Export tool

Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel. It also installs stored procedures and runs them, if that’s what you desire. Go ahead and play with it. I’ll wait. There was some positive interest on Twitter, for… Read more

0 comments, 131 reads

Posted in Born SQL with Randolph West on 20 March 2019

Sizing your Azure SQL Database

Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your Azure SQL Database? How would you go about it? Would you use the DTU (Database Transaction Unit) calculator? What … Continue reading

Read more

1 comments, 188 reads

Posted in All About SQL on 20 March 2019

Women in Tech Talk Tech

March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent woman in the Data Platform community. I had the pleasure of being one of five panelists alongside these amazing women Lori Edwards (B|T), Malathi… Read more

1 comments, 83 reads

Posted in SQLEspresso on 20 March 2019

SheLeadsTech Community

ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:

ISACA’s SheLeadsTech program seeks to increase the representation of women in technology leadership roles and the tech workforce.

You can visit the community page here: SheLeads Tech Engage Community Page. Read more

0 comments, 83 reads

Posted in Databases – Infrastructure – Security on 20 March 2019

Mixed feelings over the new truncation error

As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. Yay! But …

Yes, the new error is awesome! It gives us information about exactly what column isn’t big enough and what data is going to be truncated. And everyone’s… Read more

2 comments, 96 reads

Posted in SQLStudies on 20 March 2019

The Curiously Large CASE Statement

 

A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data per business rules to help better understand the data in a given query. In the simplest form, the CASE statement is a statement that evaluates a list of conditions… Read more

0 comments, 115 reads

Posted in SQL RNNR on 20 March 2019

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Read more

0 comments, 107 reads

Posted in SQL Server Blog Forum on 20 March 2019

Writing a presentation 4: Practice and improvement

My presentation so far is really rough. I need to improve a lot before SQL Saturday Chicago! For now, the goals are to practice the presentation and write the demos.

Practice, practice, practice

I’ve started to talk through what I have done with the slides. This way, I’m used… Read more

0 comments, 114 reads

Posted in Arthur's Blog on 20 March 2019

PASS turns 20

Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run database education group that I am proud to be associated with. My association runs to 18 of those 20 years, and 16 of those have been with attending the… Read more

0 comments, 84 reads

Posted in Mala's Data Blog on 19 March 2019

Monitoring Your Databases and Servers and…

You absolutely need to know about the servers you have under management in your estate. You need to know about the databases. Uptime, performance, behaviors, errors, corruption and a much longer list of items that will frankly fill this blog post, are very important to you. I’ve been doing work… Read more

1 comments, 156 reads

Posted in The Scary DBA on 19 March 2019

4 Reasons To Avoid VARCHAR(8000)

Watch this week’s episode on YouTube

When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype only consumes as much storage space as the string itself (plus two bytes), so even if I defined the… Read more

2 comments, 144 reads

Posted in Bert Wagner on 19 March 2019

Weekly reading #7

It is MVP Summit time! I have not made it this year unfortunately. I hope all MVPs have a greate week with the product teams in Seattle. Now take your time and read the weekly readings!

[Video] ADF Mapping Data Flows: Alter Row Transformation

15 minutes video about how to… Read more

0 comments, 120 reads

Posted in Coding Family on 18 March 2019

dbatools for the accidental DBA

dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are using it on daily basis.

But what about that IT guy whom main role is to take care of the company infrastructure not just SQL Server, and because there is… Read more

0 comments, 220 reads

Posted in DBA Mastery on 18 March 2019

Older posts