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

Archives: March 2015

System Center for the SQL Server DBA, cont’d SCOM Pack for SQL

Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start in part 1 of the series here. Today, I want to take just a minute to give you some pointers in getting started using the System Center Monitoring Pack…

Read more

0 comments, 464 reads

Posted in Coffee and SQL on 30 March 2015

PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery

Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.

Thu, Apr 02 2015 12:00 Central Daylight Time


Getting Started with Power Query by Devin Knight

RSVP: https://attendee.gotowebinar.com/register/1373099073018225154

GETTING STARTED WITH…

Read more

0 comments, 535 reads

Posted in The Smiling DBA on 29 March 2015

SQL Server 2014 BI ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014 BI. ????? ??? ?????? ????????? ?????? ???????? ????? ??? ???????? ?? ??????? ???????? ???????? ???????? ????????? ?? ????? ???????? ???? ?????? SQL Server BI ?? ?????? ??????? ??? ???? ???…

Read more

7 comments, 762 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 29 March 2015

The April Blogger Challenge

I’d encourage you to take Ed Leighton-Dick’s challenge to blog in April. Read his post, start writing, and put your post out there. Tweet about it, and be proud.

However, if you’ve never blogged, I have a modification for you. Publish privately. The important thing is to just… Read more

3 comments, 436 reads

Posted in The Voice of the DBA on 27 March 2015

Database Restores – Zeroing Out Log Files

I recently came across a question on the #sqlhelp Twitter feed that I thought was interesting.  The question pertains to whether or not SQL Server zero outs the log file when doing a restore on an existing database.

We already know that even with instant file initialization, the log… Read more

0 comments, 316 reads

Posted in John Morehouse | Sqlrus.com on 26 March 2015

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned! :)


Read more

0 comments, 135 reads

Posted in Alessandro Alpi on 26 March 2015

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned!


Read more

0 comments, 500 reads

Posted in Alessandro Alpi on 26 March 2015

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.

Here’s a short example. I’ve… Read more

0 comments, 8,019 reads

Posted in The Voice of the DBA on 25 March 2015

I am a Superhero

Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this time there were around 1,700 attendees in a special edition of SQLBits – the Superheroes edition.

Between the various sessions and the exhibition hall, I met a lot of people… Read more

0 comments, 515 reads

Posted in Guy Glantser on 25 March 2015

Toshiba Portege Z301-A Review

Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as a laptop, and only a laptop. Horror show if you need to present from it. So, I replaced it with an HP… which also gave me some troubles (try presenting… Read more

1 comments, 464 reads

Posted in The Scary DBA on 25 March 2015

Clean out all bad characters from a string.

I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. This isn’t an uncommon problem so when he… Read more

10 comments, 873 reads

Posted in SQLStudies on 25 March 2015

The Idea Book

How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be easy to add automation to [y]”, or “It would be a lot of fun to work on a project to build [z]”? For me, this has happened a lot, and… Read more

1 comments, 556 reads

Posted in Tim Mitchell on 25 March 2015

Welcome to BlobEater

I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal  from SQLskills.

I have written articles for SQL Server Central, TechNet, gathered data for SQLskills Waits and Latches Library. I have also… Read more

4 comments, 107 reads

Posted in All About SQL on 25 March 2015

Gotcha! PowerShell Array Initialization, Difference between PowerShell 2.0 and 4.0

I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell doesn’t require strongly typed variables, so why would I want to do this?

The primary reason is because it allows me to deal with an expected object type later in… Read more

0 comments, 450 reads

Posted in cjsommer.com on 24 March 2015

Using New-TimeSpan to convert friendly time

The question was this:

This is just a quick/fast snippet in response to that question, but I can think of a ton of enhancements that could made. Hopefully it will be useful as a starting point for someone to customize for their own use.

function Convert-FriendlyTime
{
    param (
        [string]$FriendlyTime…

Read more

0 comments, 345 reads

Posted in cjsommer.com on 24 March 2015

Configure SQL Server Agent using SMO

Saw this on twitter and thought I would throw it up on the blog. Easier than responding on twitter.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;

$SQLServerInstance = "MSSQLSERVER"

$srv = New-Object "Microsoft.SqlServer.Management.Smo.Server" $SQLServerInstance
$srv.JobServer.MaximumHistoryRows = 1002
$srv.JobServer.Alter()

You can manipulate most if not all SQL Server configurations through SMO. This simple post has… Read more

0 comments, 222 reads

Posted in cjsommer.com on 24 March 2015

Get-DiskSpace

My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some snippets I found on the Internet, which I threw into a script and made it my own.

It uses a simple WMI call to return a set of objects for… Read more

0 comments, 272 reads

Posted in cjsommer.com on 24 March 2015

Who is cjsommer?

I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love staying current in technology, pushing the software to its limits, as well as finding its boundaries. For me there is satisfaction in knowing the answer to something because you have… Read more

0 comments, 181 reads

Posted in cjsommer.com on 24 March 2015

My Specialty

So I was reading the following blog post by Brent Ozar and I think it finally hit me right between the eyes.

I think from a DBA perspective I would have to consider myself in the DevOPS realm, but more generally, I am an automation specialist. It’s what I truly… Read more

0 comments, 211 reads

Posted in cjsommer.com on 24 March 2015

Newer posts

Older posts