Posts

SSAS Tabular

After a brief stint, I will begin posting some bootstrap articles around  Multi Dimensional databases and Tabular.   So if you are working with SSAS, send me your questions via twitter.  And I will post some answers here.  Follow @seecoolguy

Service Broker and External Activator for Sql Server...

I ntroduced in Sql Server 2005, Microsoft's Service Broker is a Messaging Queue for Sql Server.  You can audit tables, trigger events, and even call web services (Using the External Activator). Follow this excellent tutorial by Dev Kimchi which helps you step by step and clearly explain how to setup your Service Broker messaging queue. To get started with the external activator you will require the version for the version of Sql Server you are running, click on any of the Microsoft download links and follow the install instructions: Microsoft® SQL Server® 2012 Feature Pack Microsoft® SQL Server® 2014 Feature Pack One last thing before you get frustrated installing the External Activator service on a remote server.  At least for the 2012 version, it still required .Net 3.5 installed on the destination computer/server.  If you are trying to install on a Windows 2012 server follow this helpful guide on how to get .Net 3.5 installed now that the latest packs have been releas

But can you Tuna Fish? Database Optimizations worth reviewing

Image
T here are always new articles about the web that will offer new ways on how to optimize the performance of your database. There are hardware focused optimizations that can and do improve your users data access, and you can fix things at the code level too.  Then there is optimizing your database engine to squeeze out every last bit of performance. Are you just a bit curious on how to get started? A recent blog article targets many areas in your code that you can mitigate to help deliver the best performance, there are also indexing guides which I don't think I've ever covered in my blog, check it out here: https://www.toptal.com/sql/sql-database-tuning-for-developers which covers these topics, Database Optimization (in the Codebase) Indexes Tune SQL query performance by avoiding coding loops Avoid correlated subqueries Select sparingly The use of temp tables SQL Server Performance Tuning: Execution Plans To optimize your existing indexes you can refer to

Keeping it Real (short) How to shrink a transaction log file

Image
Space, the final frontier ....  The common wisdom on your Database Files is to NEVER shrink your data files.  Space is cheap,  but it's worth knowing how to shrink the size of your data files especially when you are running out... How to Truncate Log files in Sql Server 2008 If your transaction log files are growing beyond their disk size, it's  important to consider why your log file keeps growing?  Databases Log Files will use space to quickly write to disk the many operations it requires and thus some file growth is expected when you reach beyond the initial sizing of your database.  When you notice continual growth of your transaction log file, you need to start looking at your backup strategy to help manage it.  Did you set your recovery model to the appropriate one?  Should you be performing more transaction log backups? for more information on the shrinkfile operation, consider reviewing the tech doc at Microsoft. You can also read a little more on your datab

What's up?

I'm coding that's what's up... http://xcodethis.blogspot.com

Lighting Quick Table RowCounts for your Tables

Image
If you are familiar with TSQL and want to get a row count from your tables you might be tempted to run a simple Select count(*) from myTable This however can be a lengthy wait if you have millions and millions of records. Not to mention the potential impact on a production system. Instead consider selecting your rowcounts from your system tables SELECT OBJECT_NAME(id), ROWS, indid FROM sysindexes WHERE indid < 2 AND OBJECT_NAME(id) IN ('myTableName') Looking forward beyond Sql Server 2005 and beyond the following select should be used and will provide you with the needed information as system tables access may be depracated SELECT DISTINCT OBJECT_NAME(P.object_id) AS [Name], ROWS FROM sys.indexes I INNER JOIN sys.partitions P ON P.object_id = I.object_id AND P.index_id = I.index_id WHERE I.index_id < 2 AND OBJECT_NAME(P.object_id) IN ('myTableName') So why am I searching for index smaller than 2? In short from the article below you'll find that pure data p

New Look... New Stuff

Image
Hi everyone... So some new things are going to be happening with my blog... I'm going to pick some helpful hints that help me and my fellow DBA's with what we do on a Daily or weekly basis. These should be helpful for all but you are more than welcomed to share your experiences on what Tips help you the most. One thing that is comming is an article on Wait times... I had the pleasure of trying out Confio's Ignite software. And while it does some really great things, such as pointing out where the bottle necks are for performance on your server. It can be pretty pricey and really does not introduce anything you can't already do. I'm planning on rolling out a short but continuous list of I/O wait times what they are and how to use them to boost performance on your SQL Server within the coming weeks, I will not concentrate on Sql Server 2005/2008 alone, I know that is the trend in the tech community but there are still many organizations that use Sql Server 2000,