-->
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, 646 reads

Posted in SQL Barbarian on 28 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, 177 reads

Posted in SQL Barbarian 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,487 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, 17,140 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, 539 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, 547 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, 6,897 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, 370 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, 452 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,191 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, 713 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, 211 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,601 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, 481 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, 139 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, 535 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, 459 reads

Posted in StrateSQL on 27 April 2015

Upcoming SQL Saturday Precon Sessions

I have two exciting SQL Saturday preconference training sessions coming up in the month of May!

The first is my Virtualization for SQL Server Professionals training session at SQL Saturday Rochester NY on Friday, May 15th.

Session Abstract: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction… Read more

0 comments, 312 reads

Posted in Technobabble by Klee from @kleegeek on 27 April 2015

Benefits for Some, All or Only a Few

As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can read more about it here and here (as well as here).

Let me start with an important note: I am voicing my opinion here as an individual, not an… Read more

10 comments, 382 reads

Posted in The Scary DBA on 27 April 2015

What SQL version is my SSIS package?

When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how everyone thought DTS was much better and did they really have to switch? Over the years I’ve come to appreciate SSIS. It is a very powerful and useful tool that… Read more

10 comments, 873 reads

Posted in SQLStudies on 27 April 2015

Newer posts

Older posts