Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2014

Team-based Database Development: Playing Nice With Others

Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others

If you need a summary of what’s covered in the session, the abstract is as follows:

As soon as you have more than one person on a development effort,… Read more

2 comments, 1,181 reads

Posted in Sam Vanga on 29 April 2014

PowerShell-Input-Validation Scripts

Input values are validated using various mechanisms.  let’s start by examining how you would validate input parameters in Windows PowerShell 2.0

The Inputs are validated for the below mentioned functionality

  1. PostalCode
  2. PhoneNumber
  3. EmailID
  4. IP 
  5. FileName

Download the scripts from the below link

http://gallery.technet.microsoft.com/PowerShell-Input-Validation-30ebaa51

To validate PostalCode – 99999

Function Validate-PostalCode…

Read more

0 comments, 400 reads

Posted in PowerSQL By Prashanth Jayaram on 28 April 2014

PowerShell-Input-Validation Scripts

Input values are validated using various mechanisms.  let’s start by examining how you would validate input parameters in Windows PowerShell 2.0

The Inputs are validated for the below mentioned functionality

  1. PostalCode
  2. PhoneNumber
  3. EmailID
  4. IP 
  5. FileName

Download the scripts from the below link

http://gallery.technet.microsoft.com/PowerShell-Input-Validation-30ebaa51

To validate PostalCode – 99999

Function Validate-PostalCode…

Read more

0 comments, 79 reads

Posted in PowerSQL By Prashanth Jayaram on 28 April 2014

Sorkin On Writing

I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found the part about meeting a weekly deadline for a series interesting – hugely paraphrased he says that you have to write it and let it go, there just isn’t time… Read more

0 comments, 214 reads

Posted in SQLAndy on 28 April 2014

Last Weeks Top “Reading” Links #81

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

0 comments, 170 reads

Posted in StrateSQL on 28 April 2014

[SQL Snacks Video] SQL Server Table Partitioning 103

Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two videos, I would highly encourage you to do so. In this third video I will discuss the following: How Partitioning can be beneficial in helping with blocked resource contention…

Read more

0 comments, 394 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 28 April 2014

Why Can't I Reinitialize My Subscriber?



I recently had a colleague request help with a replication problem he was having with a client.  The client was running transactional replication from a SQL Server 2005 Publisher to multiple SQL Server 2005 Subscribers and was having issues after attempting to add several articles (tables) to an existing publication.

Read more

1 comments, 399 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 April 2014

Video: Designing Stored Procedure Solutions

My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code! This month, I gave this session at the Oklahoma City SQL Server User Group‘s 5 year anniversary, and at the Alaska SQL User Group, to thousands and thousands* of attendees…

Read more

1 comments, 824 reads

Posted in SQL Awesomesauce on 28 April 2014

The default autogrowth settings do NOT come from the Model database.

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed to inherit the autogrowth settings from the model DB the CREATE DATABASE command did not. Now my initial reaction was “Of course the autogrowth settings are pulled from model.… Read more

1 comments, 273 reads

Posted in SQLStudies on 28 April 2014

How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right

2) Click Run to start setup

3) Click Ok to… Read more

0 comments, 244 reads

Posted in MSSQLFUN on 28 April 2014

Resume Generating Event (RGE)

No, I haven't lost my job. This is just one of those topics that's good to get out there. There are honestly few things that can cause you to question if you still have a job the next day, but those things still exist. There are ways to mitigate RGEs,…

Read more

2 comments, 245 reads

Posted in DBA On The Go on 28 April 2014

SQL Agent Error During Windows Failover Cluster Setup

Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and working in your Failover Cluster Manager window, you see that the SQL Agent resource is not online or you don’t see the SQL Agent resource at all. Or maybe after…

Read more

0 comments, 196 reads

Posted in Coffee and SQL on 27 April 2014

When issue is not exactly "issue"

In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.
Eg - ST012 "Consider using temporary table instead of table variable"
You can ask me - "What is wrong with table variable? Everyone suggests to use it! Even…

Read more

0 comments, 84 reads

Posted in SQL Code Guard on 27 April 2014

New Permissions in SQL Server 2014: IMPERSONATE ANY LOGIN, SELECT ALL USER SECURABLES, CONNECT ANY DATABASE and the old CONTROL SERVER

(DE)
SQL Server 2014 bringt insgesamt 5 neue Berechtigungen. Zwei von diesen sind auf Datenbank-Ebene und nur in der Windows Azure SQL Database Edition verfügbar – nicht im „Box-Produkt“.
(Danke an Erland Sommarskog für die Bestätigung und Hinweis auf die recht versteckte Notiz in der Dokumentation: GRANT Database Permissions)

Read more

DAX #1 – Learning DAX

I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works. Kathy had a comment (also an inside joke for developers I think) that for those who already have multidimensional cube and MDX skills, learning about the tabular (and PowerPivot,… Read more

3 comments, 458 reads

Posted in Sherry Li's BI Corner on 25 April 2014

Powershell Goodies

If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for Powershell ISE.   This little addin allows you to quickly search and import Powershell scripts directly from TechNet Script Center.    Currently the database section has 577 scripts in the repository,… Read more

1 comments, 747 reads

Posted in Jason Carter on 25 April 2014

Reblog: April 18 to April 24

Photo credit – JStove

Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more

0 comments, 338 reads

Posted in StrateSQL on 25 April 2014

Out for a day

I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though hopefully only slightly limited in work.

We’ll see. I’ve learned to hope for the best, but plan for the worst, and as a result, I decided to take Monday… Read more

0 comments, 194 reads

Posted in The Voice of the DBA on 25 April 2014

Friday Followup For April 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC…

Read more

0 comments, 131 reads

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

Interested in Self-Service Analytics at the PASS Business Analytics Conference?

I don’t know if you’re planning to attend the PASS Business Analytics Conference. But you’ll be missing a ton of great content especially for data, analytics, and business intelligence professionals. There’s still plenty of time to register and, if you use my discount code – BABS2B – you’ll get… Read more

0 comments, 278 reads

Posted in Kevin E. Kline on 24 April 2014

Newer posts

Older posts