Blogs about: Sql Server Management Studio
Featured Blog
Render query results as XML
Here’s a sample script for rendering query results as XML: – Declare a variable with the XML datatype DECLARE @myXml xml – Use FOR XML AUTO syntax SET @myXml = (SELECT [states]… more →
metamythian
MSSQL Express - link to download not working on MS Sites
istewart wrote 1 month ago: I had to download this tool today, and try as I might I could not find a working link anywhere on Mi … more →
SQL SERVER - Create Multiple Filegroup For Single Database
— 4 comments
pinaldave wrote 1 month ago: I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains … more →
SQL Server 2008 - Tools that Integrated with Microsoft SQL Server
admin wrote 1 month ago: Microsoft SQL Server 2008 List of Tools that Comes Together With Microsoft SQL Server 2008 These are … more →
SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
— 3 comments
pinaldave wrote 1 month ago: Regular readers of my blog are aware of the fact that I have written about this subject umpteen time … more →
SQL SERVER - Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created
— 1 comment
pinaldave wrote 2 months ago: Today, we will delve into a very simple issue that one of the Jr. Developers at my organization conf … more →
SQLAuthority News - TechEd India 2009 - Day 3 - Product Group Meeting - Final Presentations - Meeting Friends
— 2 comments
pinaldave wrote 2 months ago: TechEd India 2009 has ended today and I’ve already started missing it! This three-day event was one … more →
SQLAuthority News - TechEd India 2009 - Day 1 - Authors Tech Session - SQL Server Cheat Sheet - Meeting Great People
— 3 comments
pinaldave wrote 2 months ago: First day of TechEd India 2009 is over and when I recall the day I can say that it was truly a blast … more →
SQL SERVER - 2008 - Management Studio New Features
pinaldave wrote 3 months ago: Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008. This article desc … more →
SQL Server Management Studio on non standard port
advapi wrote 3 months ago: If you need to connect on a SQL Server on a non standard port [ i.e. 7000 instead of 1433] you … more →
Change name of table in SQL Server
Jim Lahman wrote 5 months ago: I had a reason to change the name of a table in one of the databases I am building. Here is the pro … more →
SQL Server 2008 Management Studio Trick
— 7 comments
scarydba wrote 5 months ago: I just had a Tremors moment. “Everybody knows about ‘em Earl, we just never told you. … more →
Tutorial: SQL Server Management Studio
elviejolemos wrote 6 months ago: Hola de nuevo! Aquí está el link del tutorial del MSDN de SQL Server Management Studio. Este tutoria … more →
SQL SERVER - 2008 - Change Color of Status Bar of SSMS Query Editor
— 6 comments
pinaldave wrote 6 months ago: This is one very interesting issue which I have started to follow recently. Just like any other orga … more →
Render query results as XML
Susan Delaney wrote 6 months ago: Here’s a sample script for rendering query results as XML: – Declare a variable with th … more →
SQL Server Management Studio query template
Abhi wrote 7 months ago: Last day I was working on SQL server and I got this strange error ———— … more →
SSIS/DotNetNuke module namespace error
Susan Delaney wrote 8 months ago: While working on one of my side projects the other day, Visual Studio threw an ambiguous namespace e … more →
sp_MSforeachdb
Susan Delaney wrote 9 months ago: sp_MSforeachdb is another useful undocumented Stored Procedure provided by Microsoft. Although it co … more →
Changing logical file names
Susan Delaney wrote 9 months ago: Data: ALTER DATABASE MyDatabase MODIFY FILE (NAME = ‘RestoredDBname’ , NEWNAME = … more →
SSRS data sources
Susan Delaney wrote 10 months ago: SQL Server Reporting Services I recently needed to quickly produce a list of Reporting Services … more →
Have your say. Start a blog.
See our free features →
An 
Opus
