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

Latest Blog Posts

Renaming MDF/LDF Files–SQLNewBlogger

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

I would guess many people would run into this situation at some point. A developer or DBA creates a database, then decides to rename it, but the… Read more

0 comments, 281 reads

Posted in The Voice of the DBA on 15 June 2017

T-SQL Tuesday #091 – Round-Up

Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this brought out quite a bit of variety on the posts. This is because DevOps is still… not quite cooked…(?) in many peoples minds. I think with the range of posts… Read more

5 comments, 1,154 reads

Posted in The Scary DBA on 15 June 2017

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.

Partition switch failed because : column ‘xyz’ does not have the same ANSI trimming semantics in tables ‘a’ and ‘b’

It turned out it was because the ANSI_PADDING setting was different between the two tables (well,… Read more

3 comments, 1,621 reads

Posted in SQLStudies on 15 June 2017

Solved : Microsoft SQL Server Error 3403

From its powerful internal structure, fast performance, and reliability, SQL server is now widely accessed by several enterprise users. It is used to deal with bulk transaction processing, business programs, and content management. The Microsoft SQL server is chosen for its high level security, scalability, and performance. Sometimes, corruption in… Read more

0 comments, 309 reads

Posted in Zora's SQL Tips on 15 June 2017

Data Science Virtual Machine

The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data science.  It has many popular data science and other tools pre-installed and pre-configured to jump-start building intelligent applications for advanced analytics.  So instead of you having to create a VM… Read more

3 comments, 1,625 reads

Posted in James Serra's Blog on 14 June 2017

Using ETL Staging Tables

Most traditional ETL processes perform their loads using three distinct and serial processes: extraction, followed by transformation, and finally a load to the destination. However, for some large or complex loads, using ETL staging tables can make for better performance and less complexity. As part of my continuing series on… Read more

3 comments, 217 reads

Posted in Tim Mitchell on 14 June 2017

WinDbg and SQL Server Fun

I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx (xxx = numerical value). They are located in the following directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ – sound familiar? Have a … Continue reading

Read more

1 comments, 297 reads

Posted in All About SQL on 14 June 2017

Changing default location for docker containers

A question that regularly comes up when I talk about containers is, “can you specify where the containers/images live on the host?”

This is a good question as the install for docker is great because it’s so simple but bad because well, you don’t get many options to configure.

It… Read more

1 comments, 800 reads

Posted in The DBA Who Came In From The Cold on 14 June 2017

DevOps or DataOps Either Way It’s Coming to SQL Server

For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us:

How do we approach DevOps as developers, DBAs, report writers, analysts and database developers? How do we deal with data persistence, process, source control and all the rest of the tools and mechanisms, and most importantly,… Read more

1 comments, 120 reads

Posted in SQLvariant on 13 June 2017

DevOPs and Databases — the one thing you may be doing wrong. 

This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b)  – for hosting this month’s T-SQL Tuesday event.


OK, so this DevOPs thing – what is it?

I consider myself both a… Read more

0 comments, 278 reads

Posted in The Hybrid DBA's Blog on 13 June 2017

Orchestrating SQL Server with Kubernetes

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. You can find a list of all past topics at tsqltuesday.com. This month, it’s Grant Fritchey’s (t|b) turn with his topic Databases and… Read more

4 comments, 1,474 reads

Posted in The Database Avenger on 13 June 2017

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can… Read more

2 comments, 1,442 reads

Posted in SQL with Dustin Ryan on 13 June 2017

SQL Saturday 622. Join me July 29, 2017 in Albany, NY and learn to Paint with PowerShell!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 118 reads

Posted in cjsommer.com on 13 June 2017

Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques

It is with an incredible joy and gratitude that I am able to share that I will be delivering a full-day precon (workshop) at PASS Summit 2017: Columnstore Indexes – Practical Solutions & Techniques on 31st of October 2017 in Seattle.

What should you expect ? A lot of technical… Read more

0 comments, 190 reads

Posted in Niko's blog on 13 June 2017

PASS Summit Precon on Virtual SQL Server Performance

PASS has just announced this year’s precon sessions for the PASS Summit in Seattle this October, and I am humbled to announce that my session, “Virtual SQL Servers – Right to Ludicrous Speed” has been selected for one of the Tuesday precon slots. This topic is near… Read more

0 comments, 185 reads

Posted in Technobabble by Klee from @kleegeek on 13 June 2017

TSQL Tuesday - Databases and DevOps

DevOps isn't running SQL Server in a container and pushing code to it from Jenkins

When we talk about DevOps we envision that we have the ability to check-in code, spin up a new environment, deploy, test and push that code to production and be in the pub at 4.…

Read more

0 comments, 124 reads

Posted in Ed Elliott's Sql Developer Blog on 13 June 2017

T-SQL Tuesday #91–Early DevOps

This month the T-SQL Tuesday invitation is from Grant Fritchey, my colleague at Redgate Software. Surprise, surprise, the topic is DevOps.

I write and talk about this a lot, but for this month I’ll look back at DevOps for me in 2001.

If you want to participate… Read more

1 comments, 193 reads

Posted in The Voice of the DBA on 13 June 2017

T-SQL Tuesday #91 – Start Talking

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and anybody who wants to… Read more

3 comments, 669 reads

Posted in John Morehouse | Sqlrus.com on 13 June 2017

DevOps and Visual Studio

The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps work. That said, you do need to think about the tools you’re going to use to automate those processes. Frequently the emphasis is on third party tools, but it doesn’t… Read more

3 comments, 427 reads

Posted in The Scary DBA on 13 June 2017

Buzzword Bingo

Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS. (As he put it, it was either that or execution plans.) Now I’m not highly knowlegable about DevOps myself. I mean I have a general… Read more

0 comments, 456 reads

Posted in SQLStudies on 13 June 2017

Newer posts

Older posts