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

Archives: February 2015

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!

I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of… Read more

10 comments, 8,613 reads

Posted in Koen Verbeeck on 25 February 2015

PWDCOMPARE–a hidden function of SQL SERVER TIP #88

 

I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ?

Means once you stored your encrypted password in database now next step is to compare that particular password with your input password… Read more

0 comments, 665 reads

Posted in Rajat Jaiswal-337252 on 25 February 2015

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect.

The first approach toward security to have a strong username & password and the next step is to have password in encrypted form.

Now this article will help… Read more

0 comments, 303 reads

Posted in Rajat Jaiswal-337252 on 24 February 2015

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today.  The abstract for my session is below and the recording will be available here tomorrow.  I hope you enjoyed it!

Here is the… Read more

0 comments, 819 reads

Posted in James Serra's Blog on 24 February 2015

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.

I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more

2 comments, 462 reads

Posted in Kevin E. Kline on 24 February 2015

Check Out Josh’s Blog on Creating Percentile in DAX

I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. I have worked with Josh for years at a Magenic and now Pragmatic Works. I look forward to seeing what he will be writing… Read more

0 comments, 577 reads

Posted in DataOnWheels on 24 February 2015

T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases

There are many different ways to accomplish this tasks.

Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6

The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string

CREATE TABLE  #ProcSearch  (databaseName VARCHAR(100),ROUTINE_CATALOG varchar(50),ProcName VARCHAR(128),RoutineType varchar(100),CreateDate date)


DECLARE @command varchar(1000) 
SELECT @command = 'IF ''?''…

Read more

0 comments, 6,756 reads

Posted in PowerSQL By Prashanth Jayaram on 24 February 2015

DevOps, the DBA, and the word “No”

Check out this DevOps Reactions animated GIF and caption.

It’s funny on multiple levels, but it also makes me both mad and disappointed.

I get mad because it’s 2015. Surely by now most of us, especially those who have worked in the enterprise with development teams, know that the old… Read more

10 comments, 6,582 reads

Posted in The Scary DBA on 24 February 2015

Book Review – SQL Server Internals: In-Memory OLTP

In-Memory OLTP – a potential game changing technology

Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one of them. The design team set out with a goal of reaching an order of magnitude improvement over existing technologies… Read more

0 comments, 463 reads

Posted in Anthony Nocentino's Blog on 24 February 2015

Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes

Here are my unedited chapter notes:

Chapter 1
Chapter 2
  • Collation – current version requires BIN2 on character index columns. Best to do so at the column level. Supports only sorting, comparison and grouping. Will remove the need for case sensitive code on tables and columns but not data.
  • Collate…

Read more

0 comments, 582 reads

Posted in Anthony Nocentino's Blog on 24 February 2015

SQL Cruise Caribbean 2015 Recap


UPDATED: Don't just take my word. Read the feedback from others.



I wish I could just re-post…

Read more

0 comments, 769 reads

Posted in Everyday SQL on 24 February 2015

Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked. You could download the excellent sp_whoisactive, written by Adam Machanic, which… Read more

4 comments, 7,124 reads

Posted in The DBA Who Came In From The Cold on 24 February 2015

Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked. You could download the excellent sp_whoisactive, written by Adam Machanic, which… Read more

4 comments, 230 reads

Posted in The DBA Who Came In From The Cold on 24 February 2015

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun.

SQLRally

On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

The session talks about a big… Read more

0 comments, 364 reads

Posted in Matan Yungman on 24 February 2015

Preparing a Technical Session Part 3: Writing an Abstract

So you’ve come up with a great idea for a session and now you have to translate that idea into a thorough abstract that helps both organizers and attendees understand what to expect from your session. This can make the difference between you getting a session at your favorite conference… Read more

0 comments, 5,357 reads

Posted in Devin Knight on 24 February 2015

How easy to determine table dependencies ? TIP # 86

 

Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which  SQL Server provides.

By using this stored procedure we can easily determine all the dependencies of particular table.

The stored procedure is sp_msdependencies

We can use this stored procedure… Read more

0 comments, 374 reads

Posted in Rajat Jaiswal-337252 on 24 February 2015

Missing Full Text Extensions in Express

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set up the VM I was using wasn’t sure what to… Read more

0 comments, 701 reads

Posted in The Voice of the DBA on 23 February 2015

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:

 

Generate a set or sequence without… Read more

2 comments, 602 reads

Posted in Kevin E. Kline on 23 February 2015

Book Review: Virtualizing SQL Server with VMware

It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to buy or not to buy a book, but don’t contain a lot of the “why” or “why not” to do so. But, every once in a while a book comes… Read more

0 comments, 1,139 reads

Posted in Technobabble by Klee from @kleegeek on 23 February 2015

Exam Prep 70-463: Variables and Parameters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

1 comments, 7,878 reads

Posted in Cleveland DBA on 23 February 2015

Newer posts

Older posts