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

Archives: April 2015

Restoring a database that doesn’t exist

When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 221 reads

Posted in Sheldon Hull on 28 April 2015

A Tale of SQL Server Disk Space Trials and Tribulations

#SQLNewBlogger

Details:
System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the following data files: two files in the PRIMARY filegroup, and one other file in another filegroup, plus one log file. It used to have two log files…

Current… Read more

0 comments, 5,623 reads

Posted in Todd Kleinhans on 28 April 2015

Using PowerShell to Export SQL Data to CSV. How well does it perform?

So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following post on Twitter #sqlhelp, and after I posted my response I thought that this would make a fun blog post. I have used PowerShell to export SQL Server tables to… Read more

4 comments, 21,663 reads

Posted in cjsommer.com on 28 April 2015

Windows Temporary Profile

Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc you get the message that you have been logged in with a temporary profile.
Well that was what happened to me Friday evening. My heart sank. Have I lost all…

Read more

0 comments, 592 reads

Posted in The SQL DBA in the UK on 28 April 2015

Use PsPing When Working in Azure IaaS

Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best ways for me to learn about Azure was to build out my own environment using VMs, or Infrastructure as a Service (IaaS). All of that was easy; however, once the…

Read more

0 comments, 654 reads

Posted in Everyday SQL on 28 April 2015

Moving SQL Server data between filegroups – Part 2 – The implementation

In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our two part series on “Moving SQL Server data between filegroups – Database Structures”, you can find the first article… Read more

0 comments, 7,035 reads

Posted in Anthony Nocentino's Blog on 28 April 2015

Clustered Columnstore Indexes – part 52 (“What’s new for Columnstore XE in SQL Server 2014 SP1”)

Continuation from the previous 51 parts, the whole series can be found at http://www.nikoport.com/columnstore/

Microsoft has launched Service Pack 1 for SQL Server over a week ago (15th of April was the release date I believe), and unfortunately the original release contained a bug related to SSISDB Database, while upgrading… Read more

0 comments, 435 reads

Posted in Niko's blog on 28 April 2015

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way.

Manual

The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 521 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare & deploy” way. Manual The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 19 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare & deploy” way. Manual The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 17 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 7,385 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 10 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 11 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery

In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored procedures differ from normal stored procedures in that the In-Memory OLTP… Read more

1 comments, 278 reads

Posted in The DBA Who Came In From The Cold on 27 April 2015

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery

In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored procedures differ from normal stored procedures in that the In-Memory OLTP… Read more

1 comments, 821 reads

Posted in The DBA Who Came In From The Cold on 27 April 2015

Dear Vendor: Keep My Information Secure

Dear vendor:

Dear Vendor: Keep My Information Secure

If you’re reading this, we have done business together, either directly or indirectly. You might be a retail website from which I purchase products or services. You could be a social media empire on which I share blog posts, life events, and… Read more

2 comments, 5,716 reads

Posted in Tim Mitchell on 27 April 2015

Perspective

It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me… Read more

5 comments, 581 reads

Posted in The SQL Professor on 27 April 2015

Perspective

It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me… Read more

5 comments, 195 reads

Posted in The SQL Professor on 27 April 2015

The May Blogger Challenge–Continuing On

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging.

Building on April

To make the next step in starting to blog regularly,… Read more

0 comments, 627 reads

Posted in The Voice of the DBA on 27 April 2015

Monday Morning SQL Break – April 27, 2015

It’s been a while since I’ve posted a blog post.  After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years.  Of course, analysis paralysis and my lacking php skills… Read more

0 comments, 552 reads

Posted in StrateSQL on 27 April 2015

Newer posts

Older posts