Migrating SQL Server to Azure at Scale (Pass Summit 2020)
In November 2020, for the (until then) paid conference SQL Pass 2020, my colleague Avnish Rastogi and myself, presented the[…]
Read more
Category: SQL Server
VCenter Server 4.1 Running under SQL Server pushes tempdb storage allocation through the roof
And to alleviate the problem temporarily we needed to bounce the instance and clear up the temp database files. But[…]
Read moreMax Memory Configuration set too low [SQL Server]
We have been experiencing an issue with a clustered node where instances will run extremely slow and the only process[…]
Read moreExcel X64 driver and SQL Server 2008 R2 on cluster node [Fix]
As we continued with the execution of our migration plans from SQL Server 2005 to 2008 R2 X64, we found[…]
Read moreWindowed Functions empowering analytics [#TSQL2sday]
This blog entry is participating in the T-SQL Tuesday #16 for the month of February, hosted by Jes Schultz Borland[…]
Read moreMigration to 2008 R2. Not as easy as Copy & Paste [Performance]
Better hardware and the latest SQL Server release does not always mean that things will run faster.
Read moreAllow me to sleep and focus on number crunching [#TSQL2sday]
Allowing me to sleep properly and investing time on number crunching.
Read moreWhat’s happening in 2011
So what is happening next year? Many exiting things, with a core focus on HA, DR, Analytics, SharePoint 2010, and VMware on production databases
Read moreTable Structure, Trading Maintenance with Performance [SQL Server]
With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
Read moreI/O Issues on a newly deployed SQL Server cluster attached to a SAN [Windows 2008 R2]
We executed the migration of stand-alone database servers to an active/active cluster. This was for our enterprise-wide reporting solution which includes a scaled-out deployment of Reporting Services implementing F5 BIGIP as a load balancer.
Read more