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

Archives: August 2014

SQLSaturday Orlando Marketing Plan-Part 39

Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very good week! Our standard Tuesday email will go out about 10 am this morning with topics on MVP’s in attendance and lunch. On Friday we’ll have our first “special”… Read more

0 comments, 758 reads

Posted in SQLAndy on 26 August 2014

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and… Read more

0 comments, 7,622 reads

Posted in SQL Server Rocks! on 26 August 2014

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and… Read more

0 comments, 20 reads

Posted in SQL Server Rocks! on 26 August 2014

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

Those who are facing severe issues with their environment, they can plan to test… Read more

0 comments, 606 reads

Posted in MSSQLFUN on 26 August 2014

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an error, no resultsets from any of the other instances are displayed, even if n "row(s) affected)" is displayed in the Messages tab.

This is particularly painful when querying dynamic management objects across server…

Read more

0 comments, 6,013 reads

Posted in SQL Tact on 26 August 2014

Refreshing A SQL Mirrored Database Using Powershell

 

SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and although the feature is deprecated it is still widely utilised. You can read more about it on MSDN here and Jes Borland wrote a useful post answering many questions… Read more

6 comments, 676 reads

Posted in SQL DBA With A Beard on 25 August 2014

Continuous Integration/Delivery without Testing!

Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to write code, but to deploy working code. So what if we did the automated builds and deployed them to development or QA? No errors, so I’m good, right?

Not so… Read more

0 comments, 7,270 reads

Posted in Databases – Infrastructure – Security on 25 August 2014

Last Weeks Top “Reading” Links #98

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

1 comments, 490 reads

Posted in StrateSQL on 25 August 2014

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.

Further going into details, I found that… Read more

3 comments, 3,645 reads

Posted in MSSQLFUN on 25 August 2014

The amazing never shrinking heap

This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However until recently I could never duplicate it on purpose. (You can read that as I’ve had a production problem bite me in the …. repeatedly.) At least I couldn’t duplicated… Read more

0 comments, 499 reads

Posted in SQLStudies on 25 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 2

I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell.  The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just… Read more

0 comments, 6,794 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 August 2014

The Good the Bad and the Ugly of my extended job search

Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my interview experience over the last two years starting in the Summer of 2012.  I have left out the company names out purposely because this is not a post to damage…

Read more

10 comments, 280 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 25 August 2014

Parameterization Part 2: Seven Ways to Execute Your Query

This is the second post in my series on parameterization. In the first post I wrote about plan caching and about the phases that each batch goes through before execution. I ended the previous post with a query example that demonstrates the importance of parameterization. For this post I’m going… Read more

10 comments, 8,725 reads

Posted in Guy Glantser on 25 August 2014

Speaking at SQLSaturday #336 Holland

I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!

This will be my first SQLSaturday as a speaker and I am really looking forward to it!

There are more than 160 sessions submitted by great SQL Server experts around… Read more

0 comments, 611 reads

Posted in DotNine SQL Server and more on 23 August 2014

Tips for Securing SQL Server from All Sorts of Risks

Securing SQL Server is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we have discussed about all the concepts and the precautions that can be taken to prevent databases and the accumulated components such as…

Read more

0 comments, 1,955 reads

Posted in Zora's SQL Tips on 23 August 2014

Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model

On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server, to deal with potential Denial of Service attacks and an exploit in Master Data Services. After attempting to make my way through hundreds of instances already, and all…

Read more

0 comments, 1,638 reads

Posted in The Database Hive for SQL Server DBAs on 22 August 2014

Reblog: August 15 to August 21

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

1 comments, 863 reads

Posted in StrateSQL on 22 August 2014

SQLSaturday Orlando Marketing Plan-Part 38

I just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still only tie 1 registration to all of the LinkedIn effort so far. Keep going, or ? I think I’m going to see if I can change the URL to a… Read more

0 comments, 406 reads

Posted in SQLAndy on 22 August 2014

The ALS Ice Bucket Challenge

A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver SQL Server User Group meeting, Todd Kleinhans was ready to take the challenge and asked if I’d participate.

I was speaking, but happy to do it afterwards. Here we… Read more

1 comments, 1,176 reads

Posted in The Voice of the DBA on 22 August 2014

Odds and Ends To Think About

Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but I love the video anyway because the best lesson to learn is that learning takes time, effort, and stumbles. I watch my own kids struggle with this, and think how… Read more

0 comments, 489 reads

Posted in SQLAndy on 22 August 2014

Newer posts

Older posts