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

Latest Blog Posts

Two Weeks on the PASS Board

The one absolute promise I made about serving on the PASS Board is that I would let you know what I was doing there. Well, we’re two weeks in and I figured now was a good time for a report.

Next week is my first board meeting (and I will… Read more

10 comments, 96 reads

Posted in The Scary DBA on 16 January 2015

Listen to Lead

I’ve got a question for you. Where did you learn how to listen?

Of all the coaching and consulting clients I have asked that question to, not one has had formal training to become a better listener.

Some have pointed to the works of Stephen Covey and others like him… Read more

2 comments, 89 reads

Posted in Kevin E. Kline on 16 January 2015

Dev Tools: FARR2 Launching groups of files or apps at once

There are probably a common number of apps you pull up when you pull up your system. For example, I pull up my Trello board, outlook, XYplorer, Sublime text 3, Sql server management studio, and ketarin (app updater).

Found that you can easily setup a simply alias and launch a… Read more

0 comments, 259 reads

Posted in BIT Barbarian on 16 January 2015

Find the Location of SQL Server Error Log File

This post is all about SQL Server error log files where they reside on the system. It will help those users who are not aware of the error log file.

SQL Server maintains its error event or information about error logs related messages are kept in the error log file.…

Read more

2 comments, 4,971 reads

Posted in Zora's SQL Tips on 16 January 2015

Pagination in SQL Server

It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL Skills insiders video on OFFSET and FETCH by Jonathan Kehayias (b/t) and remembered fondly an interview I did many, many years ago. As part of the… Read more

5 comments, 5,344 reads

Posted in SQLStudies on 15 January 2015

Space issues with SSIS temp files

The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before the business started in earnest for the day. One of the final jobs of the morning failed, a job that called an SSIS package that transferred some email logging to… Read more

5 comments, 4,869 reads

Posted in Ctrl-alt-geek on 15 January 2015

Mid-Week Update

Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held in Vienna at the end of February(28th Feb). David’s talk is titled   Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure.

There have a been couple of…

Read more

0 comments, 107 reads

Posted in The SQL DBA in the UK on 15 January 2015

What to Expect When Transitioning from DBA to Consultant

Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning from being a DBA to being a consultant.

We had a great conversation and covered a lot of issues. Among… Read more

2 comments, 116 reads

Posted in Matan Yungman on 15 January 2015

T-SQL to Display Weekends Between two Dates

Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered in the below SQL

Download T-SQL WeekendBetweenTwoValidDates

DECLARE @beginDate Date='20150101',
		@endDate Date='20150131'


DECLARE @Calendar Table
(CalendarDate Date Primary key, IsWeekend Bit)

WHILE @beginDate <= @endDate
BEGIN
INSERT INTO @Calendar
SELECT…

Read more

2 comments, 216 reads

Posted in PowerSQL By Prashanth Jayaram on 14 January 2015

Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms

Steve:

This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for the management of a large number of SQL Server instances.

Originally posted on JamesDataTechQ:

This blog post is about adding a new CheckBox to the SQL Tool…

Read more

0 comments, 5,216 reads

Posted in DataOnWheels on 14 January 2015

Power BI Designer

Long has the question been asked “Which Microsoft tool do I use for dashboards?”.  SSRS, Excel, PowerView, Report Builder and PerformancePoint are all candidates.  But that has all changed, and the future of dashboarding is here: Power BI Designer.

The Power BI Designer is a new companion application for Power… Read more

1 comments, 270 reads

Posted in James Serra's Blog on 14 January 2015

VMware Online Event – February 2nd

VMware has recently announced an online event for February 2nd that you don’t want to miss! Whatever it is, it’s going to be big! It also kicks off the 28 days of February event, whatever that is. You don’t want to miss this!

AMERICAS
Date: February 2, 2015
Time:… Read more

0 comments, 110 reads

Posted in Technobabble by Klee from @kleegeek on 14 January 2015

Execute the Current Statement–SQL Prompt

This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which comes about from pressing Shift+F5. Whatever statement the cursor is on, whether it’s a single line or multi-line, the statement will execute.

It can be on the first line: Read more

0 comments, 171 reads

Posted in The Voice of the DBA on 14 January 2015

Common Table Expressions Are Not Tables

There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things. The name for the T-SQL clause Common Table Expression (CTE) is actually pretty accurate. It’s an expression that looks like a table and can be used in common across the… Read more

12 comments, 6,390 reads

Posted in The Scary DBA on 14 January 2015

Excel 2013 Conditional Formatting for Columns

If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column when the values are not equal, do this:

Our starting point – we want Grape to be highlighted because it is not the same as Cherry.
Select all of column…

Read more

0 comments, 89 reads

Posted in New York City .NET on 14 January 2015

Award from MSSQLTIPS.com

Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.

I have to say it is probably my best decision in 2014 to write for MSSQLTips.com as I am not only paid decently for writing about what I… Read more

0 comments, 118 reads

Posted in DBA Philosophy on 14 January 2015

Minor ailments and Healthy SQL

One of the things that DBAs love to do is keep their servers running and healthy.  A healthy server, after all, is your ticket to a stress free day and a full night’s sleep.  Granted this not a guarantee but it sure helps make life easier.

We are always looking… Read more

0 comments, 106 reads

Posted in SQL RNNR on 13 January 2015

SQLNorthEast Usergroup 2015 dates announced (preliminary)

Mike and I have been extremely busy over the Xmas period and we’ve finally sorted dates for our 2015 instalment of the SQLNorthEast SQL Server UserGroup (@SQLNE) in Newcastle. The great news is that after much negotiation we have managed to get agreement in principal to use the same venue… Read more

0 comments, 95 reads

Posted in Chris's SQL Blog on 13 January 2015

SELECT INTO Improvements in SQL Server 2014 !

SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.

These features still remains as the top favorite and the most compelling reasons for organizations to do an upgrade, However SQL Server 2014 also includes very small but very relevant… Read more

8 comments, 7,807 reads

Posted in SQLSailor.com on 13 January 2015

Intro to Data Factory–Training on the T’s Follow Up Post

This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.

 Intro To Data Factory

In… Read more

0 comments, 88 reads

Posted in DataOnWheels on 13 January 2015

Newer posts

Older posts