-
The basic testing results of TSQL Challenge 79 - Finding the Islands is published and you can find it here .
-
Just published a sandbox for the basic testing of TSQL Challenge 79 - Finding the Islands . http://beyondrelational.com/puzzles/tsql/challenges/79/basic-testing-sandbox.aspx
-
The basic testing results of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals is published and you can find it here .
-
Just published a sandbox for the basic testing of TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals . http://beyondrelational.com/puzzles/tsql/challenges/77/basic-testing-sandbox.aspx
-
The basic testing results of TSQL Challenge 78 - Parse single field into multiple fields is published and you can find it here .
-
Just published a sandbox for the basic testing of TSQL Challenge 78 - Parse single field into multiple fields . http://beyondrelational.com/puzzles/tsql/challenges/78/basic-testing-sandbox.aspx
-
It's time for a change. This website, BeyondRelational.com , is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx?tab=default . All future...
-
April is turning out to be a busy month for me. Apart from taking the beta SQL Server 2012 certification exams and some reviews, I am also speaking at the Charlotte SSUG and at SQL Saturday #118 (Madison) and #130 (Jacksonville). I have also submitted at a couple of other SQL Saturdays, so if you do...
-
It is very important to keep revisiting one’s code – especially, when the underlying platform changes or when teams start using newer features within legacy code. Until SQL Server 2005, the typical understanding of the keyword “DECLARE” was that it had only one meaning – it was used to define an object...
-
A lot changed on the technology space this month. Today, I would write about a couple of these announcements that are bound to dominate the technology space in 2012. There are a lot of new announcements coming through, but below are the products that I would be watching out for. New Server Systems! SQL...
-
Few days before i have a requirement to find out the table name which are having a specific column with a specific value throughout the database. for that i build a query which takes <COLUMN NAME> and <VALUE> as parameter For example : A column <Col1> occurs in multiple tables in a...
-
In the previous part of this tutorial , I demonstrated the procedure to create & customize the SqlDiag.xml for use with the SQLDiag utility. I began by going through the manual editing process, followed by the graphical utility - SQLDiag Configuration Tool – from CodePlex . Today, in the final part...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-14-2012
Filed under:
Filed under: Development, Administration, Performance Tuning, Tips, SQL Server, #SQLServer, Best Practices, Guidance, DBA, Tools and Utilities, Series, Debugging
-
In one of the earlier parts of this tutorial series ( Part 06 ), I had demonstrated how to correlate the SQL Profiler trace with the Windows Performance Logs. I had used two utilities for the demonstration – the SQL Server Profiler and the Windows Reliability & Performance Monitor. In Part 07 and...
-
I have always been inspired by a particular quote from Arthur C Clarke - “ The only way of finding the limits of the possible is by going beyond them into the impossible ”. The more you think of it, the more you make sense out of it. If you decide in your mind that something is impossible, you will never...
-
In my previous post in this tutorial ( here ), I introduced the system stored procedures that would allow us to create a SQL Trace, define events and data columns to capture and start the trace using nothing but pure T-SQL code. Today, we will see the following: How to use the graphical Profiler to generate...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
03-07-2012
Filed under:
Filed under: Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series