Latest Blog Posts
Giving an SSIS security webinar with Andy Leonard
Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May 29th, at 11 AM EDT.
Register to attend the webinar!
We're going to look at the typical ETL (Extract, Transform, Load) pipeline and consider the weak points… Read more
0 comments, 60 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 May 2013
New On-Line Resources for Windows, Virtualization, and Cloud!
Ever since returning from the UK for the SQLBits conference, I’ve been snowed under a mountain of action items. I’ve got such a backlog of things to get done, emails to answer, and family to not ignore that I’m starting to feel really guilty.
So with that in mind, I… Read more
0 comments, 9 reads
Posted in Kevin E. Kline on 22 May 2013
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response time. In the meantime, poorly designed indexes, such as missing or excessive indexes on tables, indexes placed on the wrong column or inadequate index maintenance strategies, can be… Read more
0 comments, 8 reads
Posted in Basit's SQL Server Tips on 22 May 2013
SQL Server Transactions and Locking (Part 1)
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate tables. You can use transactions to complete these two operations as a unit, or if an error occurs, does not change any of the tables. Another key consideration is that… Read more
0 comments, 22 reads
Posted in Basit's SQL Server Tips on 22 May 2013
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP solution for your organization, you must ensure that the components of your OLAP solution, including relational data warehouse databases and multidimensional cubes, are designed to meet the business needs of… Read more
0 comments, 19 reads
Posted in Basit's SQL Server Tips on 22 May 2013
SQL Server index related dynamic management views and functions (Part 3)
With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function that helps database administrators (DBA) and developers to identify potential index candidates based on query history.
Checkout the part-3 of my three part article series on index-related dynamic management views… Read more
0 comments, 23 reads
Posted in Basit's SQL Server Tips on 22 May 2013
Presenting 2 sessions at SQLPASS
I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been chosen to deliver two sessions:
- Fast Performing SSAS Hierarchies: Tips and Tricks (3 hours)
Track: BI Platform Architecture, Development & Administration
Session Abstract: Depending on how they’re implemented, SQL Server…
0 comments, 19 reads
Posted in Business Intelligence & SQL Server Decaffeinated on 22 May 2013
We’re speaking at PASS Summit 2013!
PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back for part two: Mouth Wide Shut: Interviews from the Other Side of the Table.
This is our brand-spanking-new session for the interviewERs…those who question, vet, and rant… Read more
0 comments, 24 reads
Posted in SQL Awesomesauce on 22 May 2013
Index Analysis May Update
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It wasn’t for lack of using it with clients, but a lack of time to get the changes out the door.
A few months back, I added the option to… Read more
0 comments, 21 reads
Posted in StrateSQL on 22 May 2013
Holy Schnikes I’m Speaking at PASS Summit 2013
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013 in Charlotte, NC. This will be my first time to speak at this event and I can’t wait! The session I will be presenting is titled “How Active Directory Affects… Read more
2 comments, 30 reads
Posted in Ryan Adams on 22 May 2013
PASS Summit 2013 is Looking Cloudy
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be speaking at the PASS Summit, but I’m speaking about Azure… a lot.
First up, I’m going to be doing an all-day pre-conference seminar specifically aimed at getting you into Azure.… Read more
0 comments, 51 reads
Posted in The Scary DBA on 22 May 2013
View computed columns in database
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however, was a little cleaner to read and view for me.
select database_name = db_name() ,object_schema_name = object_schema_name( object_id ) ,object_name = object_name( object_id ) ,full_object_name = object_schema_name( object_id ) +…
0 comments, 59 reads
Posted in BIT Barbarian on 22 May 2013
Speaking At the PASS Summit!
0 comments, 62 reads
Posted in SQLBalls on 22 May 2013
Security Questions: Grant Permissions to All Stored Procedures
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted… Read more
1 comments, 60 reads
Posted in StrateSQL on 22 May 2013
Speaking at PASS Summit 2013!
I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting my talk “What is a BI DBA?” as a Spotlight Session (90 minutes). This is the second time I’ll have presented at the Summit and I’m honored and beyond excited… Read more
2 comments, 35 reads
Posted in SQL Chicken on 22 May 2013
On how to Googlify your SQL statements for future searching
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all agree that TSQL statements are often repeated. Ideally, snippets should be created to reduce repeated typing and let us focus on logic and content. However, some statements may not really… Read more
0 comments, 54 reads
Posted in BIT Barbarian on 22 May 2013
I’m Not Presenting at PASS Summit 2013
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing for sure, but not cause for despair. Because I’ve been lucky enough to have been accepted to speak many times in the past I don’t get too stressed out about… Read more
0 comments, 71 reads
Posted in SQLAndy on 22 May 2013
I'm thinking of hosting a series of webinars on SQL Server security
With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric. I know that's open to opinion, but basically, I searched on these three keywords:
- security
- secure
- compliance
I then looked at what came up. Of the accepted sessions, I only… Read more
0 comments, 49 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 May 2013
Using CROSS APPLY instead of a calculated variable
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working on a series of audit queries for the last couple of weeks and got thrown a bit of a curve today. The original specs included several comparisons against a date.… Read more
0 comments, 66 reads
Posted in SQLStudies on 22 May 2013
Speaking at PASS Summit 2013
I’m happy to announce that I have been selected to present
at the SQL PASS Summit in Charlotte, North Carolina this October. I’ll be delivering a session entitled “Data Cleansing in SQL Server Integration Services”, in which I’ll cover various ways to detect and cleanse dirty data using tools built… Read more
0 comments, 67 reads
Posted in Tim Mitchell on 22 May 2013



Subscribe to latest posts