Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Basic Insert Trigger Example


Below is the trigger which triggers every time a record insert in to the table to update below mentioned columns.


CREATE TRIGGERTrg_ServiceTickets ON DBO.ServiceTickets
FOR INSERT
AS
    DECLARE  @ServiceAddress         VARCHAR(481)
             ,@ServiceAddressCity     VARCHAR(60)
             ,@ServiceAddressState    VARCHAR

Read more

0 comments, 9 reads

Posted in SQL Articles by Nani on 12 May 2016

SQL Nexus

I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a few weeks ago. This is the new Nordic SQL conference that seems to be replacing the SQL Rally. I’d never been to Denmark, but the trip was easy, and I… Read more

2 comments, 212 reads

Posted in The Voice of the DBA on 12 May 2016

See you Saturday in Houston!

Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions all over! Sean’s Monster Text Manipulation: Regular Expressions for the DBA is at 11am My Designing Stored Procedure Solutions is at 2:45pm Sean’s Understanding Backups is at…

Read more

0 comments, 199 reads

Posted in SQL Awesomesauce on 12 May 2016

Use The Correct Data Type

Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.

Saying that you should use the correct data type seems like something that should be very straight forward. Unfortunately it’s very easy for things to get confusing. Let’s take a simple… Read more

8 comments, 1,499 reads

Posted in The Scary DBA on 12 May 2016

Free eBook – Modern Storage Strategies for SQL Server

I’m pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called “Modern Storage Strategies for SQL Server“.  Storage is so vitally important to SQL Server performance, but the intricacies of one side’s administrators are rarely known by the other.… Read more

0 comments, 2,985 reads

Posted in Technobabble by Klee from @kleegeek on 12 May 2016

Comparing the contents of two tables

I’ve been working on tuning a query for the last week and I’ve had to make several changes to the query’s logic. I’m always a little nervous when making those types of changes so I try to do some careful testing before I even suggest the changes to the developers.… Read more

12 comments, 2,634 reads

Posted in SQLStudies on 12 May 2016

PowerShell – SQL Database Refresh -Restore – Multiple Databases

.SYNOPSIS

The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.

.DESCRIPTION

The advantage is that the flexibility of passing restoreDbList to restore specific group of databases.

The Restore databases has three mandatory paramters

param ([Parameter(Mandatory=$true,Position=0)][String]$SourceServer – Source where you… Read more

0 comments, 795 reads

Posted in PowerSQL By Prashanth Jayaram on 12 May 2016

Find Unused Database Objects in SQL Server

Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its …

Continue reading Read more

0 comments, 218 reads

Posted in Kapil Blogs on 12 May 2016

Upcoming SQL Saturdays - June 2016

I am speaking at two different SQL Saturdays in June!

--



First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517) - I am speaking at 2:45pm on "Getting Started with Extended Events."  This is quickly becoming my favorite of the talks that I give…

Read more

0 comments, 163 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 May 2016

PowerShell – Backup Specific group of SQL Databases

<#
.SYNOPSIS

The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh databases.

.DESCRIPTION

The advantage is that the flexibility of passing a list of specific group of databases for backup.

The backup databases has three mandatory parameters

$SQLServer –… Read more

2 comments, 168 reads

Posted in PowerSQL By Prashanth Jayaram on 11 May 2016

Azure Speed Testing

Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your office?  Obviously the closest data center would probably be the best choice (each region has multiple data centers), but how do you know what data center is the… Read more

0 comments, 816 reads

Posted in James Serra's Blog on 11 May 2016

SQL Server – Cleaning Procedure Cache for a particular database

HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from …

Continue reading Read more

1 comments, 267 reads

Posted in Kapil Blogs on 11 May 2016

Azure DocumentDB – Preparing, Loading and Querying Data

Recently I have been using Azure DocumentDB to validate several business use cases for a variety of application purposes.

For those SQL DBA’s and others who are new to Azure DocumentDB, its a fairly recent entrant to the NoSQL document database world with MongoDB as its main industry competitor.… Read more

1 comments, 1,617 reads

Posted in Mr. Fox SQL on 10 May 2016

Minimum Memory Grant Query Hint

This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog about it.” There is likely to be a lot of coverage on the new features in SQL Server 2016, so I have decided to cover a new feature that… Read more

1 comments, 938 reads

Posted in The Database Avenger on 10 May 2016

Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation

Tomorrow I’ll be presenting a new session for the PASS Virtualization Virtual Chapter called “Virtual SQL Servers, Actual Performancetomorrow at 1PM Eastern time. Register for this free webinar today!

Presentation abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they… Read more

0 comments, 163 reads

Posted in Technobabble by Klee from @kleegeek on 10 May 2016

Power BI Takeover–Webinar Recording and Q&A

Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm.  Instead of our traditional 1 hour session I delivered a 3 hour workshop that took you through the end to end process of developing Power BI solutions.  The idea being to give you a taste… Read more

0 comments, 1,569 reads

Posted in Devin Knight on 10 May 2016

Data Compression in SQL Server – Pros and Cons

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU usage in some cases, outweighing the benefits of data compression. SQL Server query optimizer does not cost the overhead of expanding… Read more

Getting your Cloud on

One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that it can force you to explore things you haven’t tried before. Well that’s exactly what Wendy Pastrick (b/t) wanted us to do.… Read more

1 comments, 154 reads

Posted in SQLStudies on 10 May 2016

A Day In The Life of a SQLBits Volunteer

So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over 4 days in Liverpool last week. 2 days of full day sessions and 2 days of shorter sessions, a pub quiz, a party (literally) out of this world.

It is… Read more

4 comments, 178 reads

Posted in SQL DBA With A Beard on 10 May 2016

SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0

I have recently experienced an issue with a third-party  backup application (Commvault) that was trying to backup the databases from the SQL 2014 . It was throwing a below error

“Description: Error encountered during backup. Error: [ Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of… Read more

3 comments, 175 reads

Posted in PowerSQL By Prashanth Jayaram on 9 May 2016

Newer posts

Older posts