Adding to the SQL Server (Sydney) Users Group meeting tomorrow night ( [story:ssug-siva-harinath]): Don Vilen, SQL Server Product Manager. Don has been the Program Manager for the SQL Server Storage Engine for the past five years, and is also in town for TechEd 2006. Don will be presenting the second session for the night, so […]
You are browsing archives for
Category: SQL Server / Microsoft SQL Server / MSSQL
SQL Server / Microsoft SQL Server / MSSQL
Siva Harinath appearing at Sydney SQL Server Users Group – 25th Aug 2006
Siva Harinath (Microsoft SQL Server Test Lead) will be appearing at the Sydney SQL Server Users group on Friday 25th Aug 2006. He’ll be showing off the new data mining add-in for Excel, as well as coming features of SQL Server 2005. If you’re a user of Analysis Server 2005 or thinking of implementing it […]
Connection String Quick Reference
Often When programming with different data sources, I need to manually build connection strings. With each provider having slightly different syntax, its impossible to remember them all. Rather than hunt through documentation each time I use this website: connectionstings.com They have a good list of the most common connection strings with examples for SQL Server […]
More of SQL Server 2005 @ TechEd
I just came across a neat list of SQL Server 2005 resources from the TecEd 2006 shows. You can see the list here.
Move an object to another schema (SQL Server 2005)
To move an object from one schema to another, you can use the TRANSFER the object to its new schema using theALTER SCHEMA command. ALTER SCHEMA destination schema TRANSFER source object For example, if you wanted to move the dbo.EOYReport view to the Report schema: ALTER SCHEMA Reports TRANSFER dbo.EOYReport
Granting SQL Server 2005 Profiler Access
If you were a DBA of SQL Server 2000, you’d be familiar with the frustration that encouraging developers to use SQL Profiler as part of performance testing meant you needed to grant the sysadmin privilages. Security best practises mean you should only grant users the minimum permissions needed, and certainly not everyone should be trusted […]
Snippet: Drop all connections to a database (SQL 2005)
If you want to drop all the connections to a database immediately, you can use the following commands: USE master GO ALTER DATABASE database name SET OFFLINE WITH ROLLBACK IMMEDIATE ALTER DATABASE database name SET ONLINE Alternatively you can kill all the processes using a database with this code: USE master go DECLARE @dbname sysname […]
Snippet: Drop all connections to a database
If you want to drop all the connections on you sql server that are accessing a particular database, here’s some code: USE master go DECLARE @dbname sysname SET @dbname = ‘name of database you want to drop connections from‘ DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS […]
SQL Server 2005 @ Tech Ed 2006 Webcasts
As part of Tech Ed 2006, Microsoft has a number of live webcasts on SQL Server 2005, including Encryption, Reporting Services, Analysis Services, and Integration Services. Check out the full list of live webcasts. If you’ve missed earlier webcasts, some of them are appearing as On-Demand Webcasts that you can watch at your leisure. You […]
SQL Server 2005 Service Pack 1 Released
Microsoft has today released SP1 for SQL Server 2005, which includes the Database Mirroring feature not present in the RTM release. In addition to updating your install with SP1, you should update your Books Online to the latest version: April 2006. A summary of the updates can be read in KB 916940. The complete list […]