SDS and Ruby
A couple of months ago my good buddy Ryan Dunn contacted me about writing some Ruby samples for the new SQL Data Services that is part of the recently announced Windows Azure. (at the time it was called SSDS). I completed the samples about a month or so ago but we had to wait to announce them until......
SQLAuthority News - Download SQL Server 2005 Service Pack 3 - CTP
The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:EnterpriseEnterprise EvaluationDeveloperStandardWorkgroupFor a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New d......
Lack of practice makes imperfect
Apparently it's been too long since I've played with SQL Server databases. I say this because I made a boneheaded mistake today that obliged me to spend some quality time in the debugger. Someone asked me whether I could convert the good ol' cascading drop-down example from using an Access database......
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set with all the pieces available to make your working life easier....Did you know......
The Oslo Developer Center: Letter from the Editors
Welcome to the "Oslo" Developer Center, your one-stop shop for all things "Oslo." Do you need to learn how M works (or what the heck it is?)? Do you want to sprinkle some of that repository stuff into your SQL Server? Do you need a quick video tutorial on the "Oslo" SDK tools? Then you've come to t......
Constraint Yourself!
In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an intrinsic part of SQL and are a great way of ensuring that a business rule is done one way, one place, one time....Did you know that DotNetSlackers also publishes .net articles writt......
SQL SERVER - Simulate INNER JOIN using LEFT JOIN statement - Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any other JOINs will degrad......
Reasons to Deprecate
Tony is happy to see features and services of SQL Server deprecated by Microsoft if it is for a good reason. Good reasons include conformance with SQL Standards or rejection by the community of users; He doesn't consider Microsoft's commercial convenience to be a good reason....Did you know that Do......
SQLAuthority News - Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundament......
SQL SERVER - Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developer confused many times when they receive following error message.Msg 325, Level 15, State 1, Line 7Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptleve......
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept
This article is inspired from two sources.1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT2) Discussion with SQL Server MVP - Jacob Sebastian - SQLAuthority News - Author Visit - SQL Hour at Patni Computer SystemsI usually summarize my ......
SQL SERVER - Introduction to CLR - Simple Example of CLR Stored Procedure
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are no......
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what sort of things can you do with GIS Data? We asked an expert!...Did you know that DotNetSlackers also publishes .net artic......
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2
A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have discussed two different methods of getting datepart from datetime.Method 1:SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))Method 2:SELECT CONVERT(VARCHAR(10),GETDATE(),111)I have s......
Deploying changes to SQL Server with SQL Packager is now a lot more powerful
With the latest version of Red Gate SQL Packager v6, the user can specify any script to package. It is even possible to mix and match scripts generated by SQL Compare, SQL Data Compare, SQL Refactor and SQL Packager to create a deployment script. Suddenly, Database deployment has got a whole lot ea......
SQL SERVER - Get Common Records From Two Tables Without Using Join
I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly.Sachin Asked:Following is my scenario,Suppose Table 1 and Table 2 has ......
SQL Server 2005 Driver for PHP Cumulative Update
Microsoft has released an updated SQL Server 2005 Driver for PHP. The SQL Server
2005 Driver for PHP download is available to all SQL Server users at no additional
charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the
reading and writing of SQL Server data from within ......
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - October 2008
Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian ......
SQL SERVER - Downgrade Database to Previous Version
Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts. Recently I got email from two different DBA where they upgraded to SQL Server 2005 trial version on their production server and now as their trial version was expire they wanted......
New Date Data Types in Microsoft SQL Server 2008
In August 2008 Microsoft released
the latest version of the database server software, SQL Server 2008. SQL
Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new
MERGE statement; new data types and functions; enhanced encryption
and X......
New Date Data Types in Microsoft SQL Server 2008
In August 2008 Microsoft released
the latest version of the database server software, SQL Server 2008. SQL
Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new
MERGE statement; new data types and functions; enhanced encryption
......
SQL SERVER - Introduction and Example of UNION and UNION ALL
It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request to rewrite my article SQL SERVER - Union vs. Union All - Which is better for performance? with examples. I request you to read my previous article first to understand what i......
Cold Turkey with SQL Server Management Studio
Someone bet Phil Factor that he couldn't stop using SSMS for a fortnight just to see how he'd cope. With some trepidation, he accepted the wager. After an uncomfortable few days, he suddenly felt happier and purer in spirit...Did you know that DotNetSlackers also publishes .net articles written by ......
SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only
SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which I wrote few days ago, which will return only Numeric values from AlphaNumeric values.CREATEFUNCTION dbo.udf_GetNumeric(@strAlphaNumeric VARCHAR(256))RETURNSVARCHAR(256)ASB......
Net Developer, VB.NET, ASP.NET, SQL :Cambridge 25-35k
Net Developer, VB. NET , ASP . NET , SQL :Cambridge 25-35k . Net Developer, VB. NET , ASP . NET , SQL :Cambridge 25-35k. This is an outstanding opportunity to Read More......(read more)...
October's Toolbox Column Online
My Toolbox column in the October 2008 issue of MSDN Magazine is avaiable online. The October issue examines:
SQL Data Generator - Quickly generate unbounded amounts of real-world test data for your database with a few points and clicks of the mouse.
Blogs of Note - Dare Obasanjo - Dare is a Pro......
SQLAuthority News - Book Review - Pro SQL Server 2005 Replication (Definitive Guide)
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)by Sujoy Paul (Author) Link to Amazon (This is not affiliate link)Quick Review:This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of high......
SQLAuthority News - SQL Injection - SQL Joke, SQL Humor, SQL Laugh
It has been long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people has already seen it. However, recently by one [...]...Did you know that D......
New ASP.NET MVC Tutorials
I created three new ASP.NET MVC tutorials that were just published at the www.ASP.net/mvc website. There are both C# and VB.NET versions of each tutorial. Here are the direct links and descriptions: Creating Custom HTML Helpers Create new HTML Helpers to make it easier to generate view content. Ste......
OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s)
Between work and diaper changes I've been reading Michael Coles's book Pro T-SQL 2008 Programmer's Guide, and found this little gem (pg. 527-528):
The OUTPUT ClauseYou can use the OUTPUT clause with the the INSERT, UPDATE, DELETE and MERGE DML statements. ... The OUTPUT clause returns informatio......
SQL Server 2008: The New Data Types
Brad continues his helicopter-level view of the most interesting new features of SQL Server 2008 with a look at the new data types, their use and their significance....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles i......
SQLAuthority News - Download - Microsoft SQL Server 2008 Feature Pack, August 2008
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest ver......
Simulating autonomous transactions in Microsoft SQL Server
In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server....
SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
After reading my article SQL SERVER - 2008 - TRIM() Function - User Defined Function, I have received email and comments where user are asking if it is possible to remove trailing spaces, leading spaces, white space, tabs, carriage returns, line feeds etc.I found following script posted by Russ and......
SQL Server Analysis Services - Manipulating Data Source Views
In this article, Nidal demonstrates the steps required to manipulate Data Source Views using SQL Server Analysis Services. After a short introduction, he examines the steps in detail with the help of relevant screenshots and code listing.Did you know that DotNetSlackers also publishes .net articles......
SQL SERVER - 2008 - TRIM() Function - User Defined Function
I just received following question in email by James Louren.“How come SQL Server 2000, 2005 does not have function TRIM()? Is there any way to get similar results.What about SQL Server 2008?”James has asked very interesting question. I have previously wrote about SQL SERVER - TRIM() Function - UDF ......
SQL Summit 2008: I Am the Governor
After Kalen's excellent keynote our SQL Server MVP Tibor Karaszi entered the stage to dive into the new Resource Governor, one of the features that are there to strengthen the Maintainability aspect of SQL Server. The resource governor is added to the Enterprise version of SQL Server 2008 and give......
SQL Summit 2008: Key Note
SQL Summit has been touring Sweden this week and today we've finally got to the grand finale at "China Teatern" in Stockholm. With 600+ attendees in all four cities the tour has been a blast with a lot of interesting discussions. This morning I had the good fortune to listen to Kalen Delaney giving......
SQL Summit 2008: The Compression Session
At TechEd (http://www.lowendahl.net/showShout.aspx?id=169) last year this feature got a massive round of applauds. The ability to compress backups and data- and log files. Kalen gave a great talk on this today where she show cased the benefits you get from the new compression features. Since large......
The Bejeweled Puzzle in SQL
Alex Kozak provides another SQL puzzle to hone your SQL Skills with....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
Aspose.Total for Reporting Services Q3 2008 Released
Aspose.Total for Reporting Services Q3 2008 release includes many new and improved features in this suite of Microsoft SQL Server Reporting Services Rendering Extensions. Now you can export RDL reports to multiple file formats like DOC, DOCX, HTML, RTF, WordML, PDF, PPT, PPS, XLS, XLSX and Spreadsh......
SQLAuthority News - SQL Server 2008 - Microsoft Certifications for 70-432 70-433 70-450 70-452
I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference.Exam 70-432 - TS: Microsoft SQL Server 2008, Implementation and MaintenanceInstalling a......
Physical data organization and indexing
This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database. ...
SQL SERVER - 2008 - High Resolution Wallpaper and Screen Saver
Recently I came across two very interesting ‘objects’ of SQL Server 2008.SQL Server 2008 High Resolution Wallpaper (click on image to see larger version)SQL Server 2008 Screen Saver Click Here to DownloadReference : Pinal Dave (http://www.SQLAuthority.com)...Did you know that DotNetSlackers also pu......
SQLAuthority News - Author Visit - SQL Hour at Patni Computer Systems
Ahmedabad SQL Server User Group has started organizing a special event, “SQL Hour”, where we visit IT companies and interact with the SQL Server professionals. We had the first meeting this Saturday, 4th October 2008 at Patni Computer Systems, Gandhinangar.This meeting was lead by SQL Server User G......
Microsoft Outlines Next-Generation Databases
Microsoft is planning to enhance the BI capabilities in the next version of its flagship SQL Server database, the company revealed today, as it kicked off its second annual Business Intelligence Conference in Seattle....Did you know that DotNetSlackers also publishes .net articles written by top kn......
MS BI Conference 2008 - First Impressions
It has been over a year since I last blogged, but I want to restart with some posts about the BI Conference I am attending this week.
Chris and I flew to Vancouver yesterday and drove down to Seattle in a Camry Hybrid. Sitting in the lineup at the US border for an hour drained the batteries on th......
Named Capture for SQL Server connection strings
Capture the information from a SQL Server connection stringDid you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
SQL Server Analysis Services - Creating Data Source Views
Now it is time to go practical in our business intelligence project as we have provided enough concepts. The first step in creating BI projects is to provide data sources to build your model out of. In this article, Nidal examines the different aspects of creating data source views using SQL Server......
SQLAuthority News - Upgrade SQL Server With SA Renamed - Rebuild System Databases - SQL Server 2008
I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them.How to Rebuild System Databases in SQL Server 2008Rarely but sometime there i......