You are browsing archives for
A new home for the SQL Server engineering team to communicate important information about SQL Server with the community. We have migrated several SQL Server related blogs to this new home in the SQL Server TechCommunity. Click here for the new SQL Server Engineering Team blog. There’s also a list of links to some of their […]
Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]
I’d like to tell my junior self that in 10 years, there wasn’t a single bug I didn’t eventually solve one way or the other. Even bugs that seem extremely scary, are eventually conquered. — Read on michaelscodingspot.com/2019/01/10/11-things-i-wish-i-could-tell-myself-as-a-junior-software-developer/
Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]
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 […]
Its been a busy few weeks for me and I haven’t had as much time to catch up on my reading as I’d have liked. This is the list of things that I have been / trying to read. Software Development at Microsoft Observed Microsoft Research paper on developers� typical tools and work habits and […]
Ahead of the final release in December 2006, Microsoft have released SQL Server Compact Edition RC1. SQL Server 2005 Compact Edition is a very lightweight, in process relational database engine for use in desktop applications and mobile devices. It has an extremely small footprint (~3MB) and minimal overhead. It won’t use any where near as […]
Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]
Going through my reading material today, I came across this post by the Microsoft SQL Server Development Customer Advisory Team on using SQL Server 2005 Enterprise Edition to load 1TB (yes terabyte) in less than an hour. Mind you they did have an a HP Itanium2 Superdome with 64 CPUs, 256GB RAM and a SAN […]
A quick list of things I am / have been reading in the last week. Metadata tool and whitepaper for BI components SQL 2005 Metadata Samples Toolkit and whitepaper now available SQL Server 2005 Business Intelligence Metadata Whitepaper SQL Server 2005 Business Intelligence Metadata Samples Toolkit Indexes: An Overview and Maintenance for Performance Recovery Planning […]
