sugeshkr.blogspot.com
Sugesh's BLOG: November 2009
http://sugeshkr.blogspot.com/2009_11_01_archive.html
Saturday, November 28, 2009. Consolidating our blogs into one website. Me, Vidhyasagar and Deepak rangarajan, we have decided that we would be posting our all articles, reviews, scripts and suggestions in SQL-ARTICLES. Website moving forward. I will be moving all articles from the blog to the website. The blog will be active for next few weeks before I finally call for SHUTDOWN. I would be happy to redirect all my users to our websites, Please find useful links below. Posted by SugeshKumar Rajendran.
sugeshkr.blogspot.com
Sugesh's BLOG: Get Details for Month for any given Date
http://sugeshkr.blogspot.com/2011/01/get-details-for-month-for-any-given.html
Sunday, January 16, 2011. Get Details for Month for any given Date. The given script below will give details for a given date as below. 1 First Day of the month along with the Weekday. 2 Weekday of the Given date. 3 Last day of the month along with the Weekday. SELECT @date = GETDATE() - INPUT YOUR DATE HERE. SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date)-1),@date),101) AS DateofMonth,datename(dw,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date)-1) ,@date),101) as Week Day,. DateofMonth Week Day DayofMonth.
sugeshkr.blogspot.com
Sugesh's BLOG: August 2009
http://sugeshkr.blogspot.com/2009_08_01_archive.html
Tuesday, August 18, 2009. For those who are trying to mail me or looking out reasons finding why I am not online in any of the messangers. The answer is here. I will be out for vacation till mid of september. I will check mails few times a week but no more than that. If i don't write back to you, Please wait. Many thanks. Posted by SugeshKumar Rajendran. Links to this post. Thursday, August 13, 2009. Virtual TechDays: FREE Technical Training Opportunity. Click Here to Register. Links to this post. I hail...
dotnetvj.blogspot.com
Me & My Little Techie.......: May 2009
http://dotnetvj.blogspot.com/2009_05_01_archive.html
Me and My Little Techie. A place to learn from Little Techie. Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year. Saturday, May 30, 2009. TSql Unit Test Generator. I found one tool which is very interesting to generate the Test Scripts for TSQL programs automatically. The tool , which I am talking about is TSql Unit Test Generator. Posted by Vijaya Kadiyala. Friday, May 29, 2009. 60 Seconds with Michael Coles.
sugeshkr.blogspot.com
Sugesh's BLOG: January 2009
http://sugeshkr.blogspot.com/2009_01_01_archive.html
Wednesday, January 14, 2009. Introduction to SQL Server Trace Flags. 160; . This article takes you to describing about the Trace Flags and its usage in SQL Server. 160; . 160; . 160; . 160; . Trace flags can be enabled at session level or global level. . Session level trace flags are available and active for that connection whereas Global Trace flags are available and active throughout the server. SET QUOTED IDENTIFIER ON. The behavior o...
sqlstad.nl
Rants and Rambling Archives - SQL Stad
http://www.sqlstad.nl/category/rants-and-rambling
This is my world. Pretty up your KeePass. No One Listens To Me! Part 2 – Colleagues. My SQL Server journey with Linux. SQL Skills Paul Randal Blog. Technet Learn SQL Server 2008. Enter your email address to subscribe to this blog and receive notifications of new posts by email. The posts, opinions and other information within this blog are my own and do not represent the opinions, policies or minions of my employer. Scripts are provided as is and should be used with the appropriate level of caution.
sqlconcept.com
BI « sqlconcept.com
http://sqlconcept.com/category/bi
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
sqlconcept.com
Baselining « sqlconcept.com
http://sqlconcept.com/category/baselining
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. SQL Server 2012 Full-Text search and XML Search - the Wiki project. Finally, here are some results from the Wiki project. After a few days of development, here is the accounting for the wiki project:. Desktop PC with 8Gb RAM, single home use HDD. SQL Server 2012, using XML and Full-Text search. The total amount of data to be imported: 39.2 GB. The rea...
sqlconcept.com
Becoming a sponsor « sqlconcept.com
http://sqlconcept.com/becoming-a-sponsor
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. So far I have been keeping this site away from advertisement at any rate. And yes, the rate is high. I pay out of my pocket for:. My family and friends’ free time. However, I am open to suggestions. If you think that this site should get colored by advertisement – feel free to drop me a line. And make me an offer. Who knows, I might go for it.
sqlconcept.com
My Articles « sqlconcept.com
http://sqlconcept.com/my-articles
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. HDDs, SSDs and Database Considerations. By Feodor Georgiev, 09 January 2013. In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work and looks into the considerations every DBA should have in mind when choosing / working with SSDs. Read more…. How come the Hourglass? As the volume of data increases...
