Archives: April 2013
here is a solution, you can save all…
Yesterday I had the opportunity to speak at the first ever SQL Saturday Fargo! Jason Strate (b | l | t) and his wonderful wife Sarah (t) and the rest of the team came together and coordinated the entire event. For a first event, this… Read more
- Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining an inventory of authorized devices/etc. Do you know all the servers running SQL and would you know if someone set up a new one?
- Add this blog about servant…
I'm also going to be the MC for the SQL Iron Chef BI presentation today. Before the festivities being I wanted to upload my deck and Demo, a…
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront. As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.
Some posts from… Read more
Today has been quite the day! This afternoon I presented for the SQL PASS Performance Virtual Chapter and tonight I spoke to the Gulf Coast SQL Server Users Group. I presented my Virtualizing Business Critical SQL Servers presentation, and really enjoyed the conversation that we had. Thank you again,… Read more
by Steve Bolton
Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind of disclaimer to the effect that I’m writing this in order to learn the material faster (while simultaneously providing the most underrated component of SQL Server some badly needed free…
Today I was fortunate enough to be able to give a new presentation to the SQL PASS Performance Virtual Chapter called ‘It’s All About the Performance, Right?’ The feedback I have received has been overwhelmingly positive, and I would like to thank the coordinators and all of the attendees! Your… Read more
Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April 6, flew to Las Vegas for the new SQLintersection conference at the MGM Grand, and then flew to Chicago to speak at SQL Saturday Chicago.
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all of these sources, it is easy to forget that there are white papers available from Microsoft. It is important that we make an effort to read the white papers that… Read more
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the extra money spent would be well worth it. But that is not always the case, and sometimes who have to help them to understand, like most things in… Read more
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Speaker: Julie Koesmarno
Date and Time: 5/10/2013 11:30:00 AM CST
BIO: Julie Koesmarno is a consultant in SQL… Read more
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact on your tables. This post will look at the table side of Filestream and how you get your binary data into the database.
Let’s assume you have a filestream… Read more
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate my work?
In DBA world, we love “no news is… Read more
It has been a little while since I posted something and I’ve been meaning to finish off this blog for a few weeks now, but I have been a little busy with the arrival of my 2nd son (and have been distracted by my new Alienware laptop!)… Anyway I recently… Read more
Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to move two tables(data and index)to different drive all together a different filegroup. This would give the best IO performance. Those two tables have ‘N’ indexes. Manually scripting ‘N’ index… Read more
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks, and presented you with an overview on how to troubleshoot and resolve blocks using dynamic management views and Activity Monitor. After I wrote this article, I… Read more
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level roles because in SQL Server, every database user is automatically assigned to the public database role, and you cannot remove public database role from SQL Server… Read more
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or more selected columns. SQL Server automatically creates indexes when you define a primary key or unique constraint. You can use indexes to manage and track rows in a table or… Read more