Microsoft SQL Server Books
You are browsing archives for
Tag: SQL Server
Why are my Covering Indexes not working in SQL Server?
Rob Farely has posted a great article on why your covering indexes in SQL Server may not be getting the perfomance you are expecting. Covering, schmuvvering – when a covering index is actually rubbish If you use covering indexes but SQL Server keeps ignoring them – read Rob’s article for some reasons why.
Security � How To Assign Rights To SQL Server Database Objects
Piotr Rodak has a great article on Security – How To Assign Rights To SQL Server Database Objects and why you should not assign rights to the public role and why assigning rights to roles instead of users gives you much more flexibility. He also covers why you should only grant permissions to your stored […]
Queensland SQL Server User Group Meeting Tonight
QSSUG Meeting This Thursday – 26th of November The emerging field of "Location Intelligence" brings the worlds of Geographic Information Systems (GIS) and Business Intelligence (BI) together. These capabilities are now available with SQL Server in a no-coding, user-driven environment provided by the Integeo (www.integeo.com) Map Intelligence product. SQL Server 2008 also introduces a […]
Answer: How do you create a byte with the value of 00000001 in SQL Server?
My team mate Pi asked me today: how do you create a byte with the value 00000001 in SQL Server? The answer is to create an integer representation of the byte’s value, and cast it to binary. SELECT CAST(CAST(1 AS TINYINT) AS BINARY(1)) The output in Management Studio is: 0x01 (Management Studio outputs binary fields […]
Julian!? Where are you?
Well I’ve definitely been "missing" on my blog lately. Between work commitments, a long daily commute, and personal projects, I’ve had no time to post much content on my website. As of last week, I started working some days remotely; from home. Its been quiet a good change, and now that I have less distractions: […]
How to Connect to a SQL Server Compact Edition Database with Management Studio
Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio. Change the Server Type to SQL Server Compact Edition. For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a […]
What I’m Reading 18 April 2007
International Considerations for Database and Database Engine Applications http://msdn2.microsoft.com/en-us/library/ms190245.aspx Strategies for Partitioning Relation Data Warehouses in SQL Server http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx Physical Database Storage Design http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx International Considerations for Notification Services http://msdn2.microsoft.com/en-us/library/ms172557.aspx How MSN Messenger and MSN Hotmail scales with SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx Scaling out SQL Server 2005 http://msdn2.microsoft.com/en-us/library/aa479364.aspx Database Mirroring FAQ http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx Database Mirroring http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx […]
Updated SQL Server 2005 Books Online (help) Available Now (Feb 2007)
As SQL Server 2005 continues to grow and change, the Books Online / help files are also updated. Keep your help files up-to-date by downloading the latest copy. Download SQL Server 2005 Books Online Feb 2007 version.
SQL Server 2005 – Service Pack 2a (SP2a) Update
Downloaded and installed Service Pack 2 for SQL Server 2005? Well here’s a reason to download and apply it again. A few days after releasing Service Pack 2 for SQL Server 2005, Microsoft has re-released it with an additional fix for maintenance plans. If you have already applied SP2, you will need to apply this […]