THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tools   (RSS)
Showing page 5 of 7 (70 total posts)
  • Partition Details Custom Report - enhanced

    Recently my fellow friend and colleague Yoni Nakache drew my attention to the nice custom report which can save valuable time to any DBA - it returns number of rows per partition along with partition boundaries and filegroup data. The rdl can be found here at Codeplex. What was definitely missing is space usage information - reserved / used space ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on July 7, 2009
  • Spooky: What do you connect to?

    I only recently discovered that SSMS will connect to different things. For instance, press the ''New query'' button. What were you connected to? The answer is the same server as your ''current'' server. But what is the current server? It is the server where you happened to have focus when the pressed the ''New query'' button. So, can you say ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 26, 2009
  • Management Pack for SQL Agent Alerts

    I have finished my article about suggested SQL Server Agent Alerts. Perhaps calling this a ''Management Pack'' is OTT, but hopefully it will be useful to some of you folks. We are talking about having Agent sending email to us when SQL Server writes messages to EventLog. The functionality has been in the product since version 6.0, but I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 1, 2009
  • sp_altermessage is back in business!

    Just a quick note that we again can modify whether system messages are to go to eventlog/errorlog again. I.e., we can change the is_event_logged column in sys.messages. This is very valuable in general and specifically is you want to define Agent alerts (for which Agent polls the Eventlog). For instance: SELECT * FROM sys.messages WHERE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 14, 2009
  • Match those types!

    This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the column side - not the literal side of your query. What does that mean? Consider below: WHERE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 28, 2009
  • Did You Know? Troubleshooting Tools Update

      Last May,  I blogged about free troubleshooting tools for SQL Server and today I received a comment that one of the tools listed seemed to no longer be available.  So I thought I would publish a refresh. There are dozens of great tools available, and I'm not even pretending that I am going to list them all. This post is really ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 23, 2009
  • Update of SQL Server 2008 Feature Pack

    I just learned (thanks Josefin) that we now have an update of the SQL Server 2008 feature pack - the October ''edition''. Stuff like download of command-line tools, driver for PHP, native client, sync framework, upgrade advisor, bunch of BI related utilities and such. Check it out at: ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2008
  • Rebuild master in SQL Server 2008

    You might have read an earlier blog entry about my problems to remove a Data Collector (DC) information in SQL Server 2008. I still haven't found any info on how to do this, but my questions in the MVP group triggered some activity. Bob Ward looked into how to rebuild the system databases. This was on my list to try (after removing DC config and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 29, 2008
  • Missing F8 or ctrl-N in SSMS 2008?

    Short story: Turn on 2000 keyboard layout and then back to Standard layout. Long story:  This topic has been discussed in both the MCT (MS Certified Trainer) as well as MVP groups. Also, see http://sqlblog.com/blogs/andy_leonard/archive/2008/08/08/sql-server-2008-management-studio-function-keys.aspx, including the comments. The ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 26, 2008
  • Parent-Child Dimension Table Naturalizer

    Parent-Child dimensions is an important feature of Analysis Services. Parent-Child dimension allow flexibility in the dimension modeling for scenarios such as Bill Of Materials, Chart of Accounts, Employee Organization Structure and others. However, this flexibility comes with the cost. Overuse of parent-child can cause performance problems. ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on August 26, 2008
Privacy Statement