Skip to main content

Get free technical eBooks on SQL Server 2017 from Microsoft

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 […]

11 things I wish I could tell myself as a Junior Software Developer – Michael’s Coding Spot

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/

SQL Server Table Function Performance

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 […]

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 […]

Optimising SQL Server 2005 TempDB

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 […]

SQL Server Agent Error: [LOG] The data portion of event 17052 from MSSQLSERVER is invalid

If you’re following Microsoft’s Best Practice recommendations for securing SQL Server 2000, you should be running the SQL Server and SQL Server Agent services under separate domain user accounts (not the Local System account). Whilst setting this up you may encounter this error: [LOG] The data portion of event 17052 from MSSQLSERVER is invalid Adding […]