Kick Spy!, Kick Zeitgeist and Kick Widgets
dbalink.wordpress.com — I was having a problem accessing a folder via an extended procedure. The extended procedure accepts a DirectoryInfo variable (File Path) and it returns the File Size and File Count within the folder (much like right-clicking a folder and choosing the “Properties” from the context menu). I need the info to monitor the file size of specific folders for a SSRS report. read more...
dbalink.wordpress.com — This is a cool whitepaper (sponsored by Quest Software) that maps out what to expect in the future in the DBA field. read more...
dbalink.wordpress.com — DBA’s use index to optimize the performance of their databases. They either create or drop indexes according to the current needs of their system. Using the Dynamic Management Views (DMV) and the other related catalog views, DBA’s are able to analyze the statistics for indexes. read more...
dbalink.wordpress.com — In this post let’s move a data file from its default location to another location. I have created a database I called “Test” for the demo. First let’s just check where the data file is currently stored: read more...
dbalink.wordpress.com — What is the cause of the stackoverflow.com downtime last October 31, 2008? read more...
dbalink.wordpress.com — So finally the clamor (I’m exaggerating) for SQL Server 2005 SP3 is finally heard! Four days ago SQL Server 2005 SP3 CTP has been announced. An earlier announcement gave us a heads up. read more...
dbalink.wordpress.com — This question posted on StackOverflow.com caught my attention. This is a common data requirement specially in Data Analysis. It goes like this: read more...
dbalink.wordpress.com — Now, for the very first time ever, a reliable and authoritative SQL Server Training Resource has come to life. This is some serious stuff. A heaven-sent goodness to the SQL Server Community! read more...
dbalink.wordpress.com — Sometimes we need to install a dynamic link library to take advantage of extended stored procedure in SQL Server. So you have installed it through the Extended Stored Procedure GUI. You double checked that the dll exists in the MSSQL\Binn directory. But then when you tried to execute the procedure you received this Error: Cannot load the DLL C:\Microsoft SQL Server\MSSQL\Binn\dllname.dll, or one of the DLLs it references. read more...
dbalink.wordpress.com — Okay, these are at least the two ways you can query the Metadata in SQL Server (TSQL). The first one is like what I’ve already shown here, which has the following TSQL cod read more...
dbalink.wordpress.com — I previously posted about finding user table basic information. In this post, let us use a handy TSQL to find all the Primary Key Constraints and the tables they are associated with. read more...
dbalink.wordpress.com — Browsing stackoverflow for SQL Server tags has now become a habit that I do on my free time. For some reason I missed this interesting post about Hidden Features in SQL Server. read more...
dbalink.wordpress.com — One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can add a parameter value “ALL” to return all of the desired result. read more...
dbalink.wordpress.com — You want to know the Host name of your SQL Server? Here’s how to do it: read more...
blog.wekeroad.com — I've been toying around with reorganizing the default MVC template and thought I would share it with people. I like the way it's come together. read more...
dbalink.wordpress.com — Sign Up now for the Southern California Code Camp!! read more...
Sponsored Link: www.carlist.ie
Ads by The Lounge
adminjew