Blogs about: Sql Server
Featured Blog
SQL Server的一些Script
SQL Server的一些Script 1. 显示某一列在数据库的哪个表中。 select * from information_schema.columns where table_catalog=’databaseName’ and column_name in (‘columnName’) 2. 显示数据库中每个表的大小（原文） EXEC sp… more →
development notes
Service Broker Across two databases on the same instance
wrote 2 hours ago: This post modifies the project contained in Service Broker with In a Single database by splitting th … more →
Service Broker In A Single Database
wrote 3 hours ago: This post demonstrates how Service Broker can work within a single database. The example here demons … more →
%1 is not a valid Win32 application
wrote 3 hours ago: This one took up way too much time in my day today, and I still haven’t figured out why this h … more →
Tips 'N' Tricks - SSIS - Define you own Keyboard Shortcuts in SSIS Package Designer
wrote 5 hours ago: SQL Server Management Studio (SSMS) has various shortcuts. Comparatively, there are less shortcuts i … more →
Detecting Database Option Changes with DDL Triggers
wrote 12 hours ago: One of the keys to managing a large production SQL Server environment is being aware of changes that … more →
70-488 – Implement an SSIS Solution – Using Variables
wrote 13 hours ago: Requirement Implement package logic by using variables This objective may include but is not limited … more →
SQL Server Date Formats
wrote 18 hours ago: One of the most frequently asked questions in SQL Server forums is how to format a datetime value or … more →
Pool backend discovery failed. Failed to execute the reconfigure command
wrote 19 hours ago: Yesterday I have to repro cases from OCS, so the point is I have to move OCS DB to another server an … more →
Developer Training - Employee Morals and Ethics - Part 2
— 4 comments
wrote 22 hours ago: Developer Training - Importance and Significance - Part 1 Developer Training – Employee Morals … more →
New Metadata Discovery Features in SQL Server 2012
wrote 1 day ago: It has always been possible to interrogate SQL Server for metadata (schema) information. You can eas … more →
Tips 'N' Tricks - T-SQL - An Elegant way to CREATE or ALTER Stored Procedures in One-Go for Easy Maintenance
— 1 comment
wrote 1 day ago: While working with Stored Procedures, we often modify the them, during the course of maintenance, as … more →
Mas cosas con esto de los Logins(Inicios de sesión)
wrote 1 day ago: Pues mi peregrinar por esto de los Logins (Inicio de sesion), al parecer no ha terminado. Al mover u … more →
How to count no. of tables and Procedures in a particular Database in Sql Server
wrote 1 day ago: Often we need to check the number of tables and number of procedures we have written in a database. … more →
SQL Server - DDL vs. DML Triggers
wrote 1 day ago: Although, DML and DDL triggers are used for different purposes, there are some similarities and diff … more →
Using SQLCMD to your advantage
wrote 1 day ago: A few weeks ago, I came across something called SQLCMD (or SQLCommand). I’ve never heard of th … more →
The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service
wrote 1 day ago: Alright, the other day I was installing SQL Server 2008 R2 (same problem occurred in 2008 as well), … more →
Developer Training - Importance and Significance - Part 1
— 15 comments
wrote 1 day ago: Developer Training - Importance and Significance - Part 1 Developer Training – Employee Morals … more →
SSMS - Specify Port Number while Connecting to Remote SQL Server
wrote 2 days ago: Sometimes SQL Server is configured to use a different Port Number than the Default Port Number (1433 … more →
Spoke in Samedi .NET Montreal - Saturday May 26th
wrote 2 days ago: Link: http://www.dotnetmontreal.com/events/35247812/?eventId=35247812&action=detail Download sli … more →
Have your say. Start a blog.
See our free features →
