mattsql.wordpress.com
Space issues with SSIS temp files | ctrl-alt-geek
https://mattsql.wordpress.com/2015/01/15/space-issues-with-ssis-temp-files
Information is that which surprises us. Another great reason to enable remote admin connections. The most recent backup problem →. Space issues with SSIS temp files. January 15, 2015. The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before the business started in earnest for the day. One of the final jobs of the morning failed, a job that called an SSIS package that transferred some email logging to the data warehouse. Log on to the server using the ac...
markread.net
Resources – Mark Read
http://markread.net/resources
Ramblings of a sql solution architect. A list of resources I trust you’ll find handy at some point … plus some light hearted SQL comedic relief. SQL Server History (Wiki). Microsoft SQL Server Home Page. Volume License Service Center (VLSC). Microsoft SQL Server Support Lifecycle. SQL Build and Patch Releases. SQL Max Capacity Spec. Microsoft Power BI Home Page. Microsoft Power BI Community. Microsoft’s Power BI Youtube Channel. MSDN SQL Server Community Forum. SQL Server Customer Advisory Team.
sqlnz.blogspot.com
SQL Server Blog: July 2013
http://sqlnz.blogspot.com/2013_07_01_archive.html
Friday, July 12, 2013. Here are some good sessions I found on SQL Server 2014 and the In-Memory OLTP. Codenamed ‘Hekaton’) feature. Microsoft SQL Server In-Memory OLTP: Overview of Project "Hekaton". This session introduces the motivations and high-level design of the in-memory OLTP system, and Rick Kutschera (from BWin. Sharing their experience migrating to the new ecosystem. Microsoft SQL Server In-Memory OLTP Project "Hekaton": App Dev Deep Dive. Subscribe to: Posts (Atom). SQL Server codename “...
sqlnz.blogspot.com
SQL Server Blog: January 2014
http://sqlnz.blogspot.com/2014_01_01_archive.html
Saturday, January 25, 2014. The SQL Server 2012 Feature Pack is a collection of stand-alone packages which provide additional value for SQL 2012. You can download the feature pack from here: http:/ www.microsoft.com/download/en/details.aspx? Subscribe to: Posts (Atom). Show Database last access time. Here is a script that I use to get info of when a database has last been accessed without having to set up a trace Note : It gets it in. Replication and AlwaysOn Availability Groups. The following script dis...
sqlnz.blogspot.com
SQL Server Blog: Tuning the Performance of Backup Compression in SQL Server
http://sqlnz.blogspot.com/2013/08/tuning-performance-of-backup.html
Monday, August 05, 2013. Tuning the Performance of Backup Compression in SQL Server. Here is a great read on Tuning the Performance of Backup Compression in SQL Server. Http:/ sqlcat.com/sqlcat/b/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx. And a cheeky query to help give you a guide on the size of your backup if it was compressed! Bdatabase name 'Database Name',. CONVERT (BIGINT, b.backup size / 1048576 ) 'UnCompressed Backup Size (MB)',. Here i...
sqlnz.blogspot.com
SQL Server Blog: January 2012
http://sqlnz.blogspot.com/2012_01_01_archive.html
Monday, January 09, 2012. Free SQL Server Tools, Software and Utilities. Free SQL Server Tools, Software and Utilities. Http:/ www.sqlserverutilities.com/SQL-Server-Utilities-Free-SQL-Server-Tools-Software-and-Utilities-for-the-DBA-and-Developer.htm. Subscribe to: Posts (Atom). Show Database last access time. Here is a script that I use to get info of when a database has last been accessed without having to set up a trace Note : It gets it in. Replication and AlwaysOn Availability Groups. The following s...
sqlnz.blogspot.com
SQL Server Blog: Hekaton Explained
http://sqlnz.blogspot.com/2013/07/hekaton-explained.html
Friday, July 12, 2013. Here are some good sessions I found on SQL Server 2014 and the In-Memory OLTP. Codenamed ‘Hekaton’) feature. Microsoft SQL Server In-Memory OLTP: Overview of Project "Hekaton". This session introduces the motivations and high-level design of the in-memory OLTP system, and Rick Kutschera (from BWin. Sharing their experience migrating to the new ecosystem. Microsoft SQL Server In-Memory OLTP Project "Hekaton": App Dev Deep Dive. Subscribe to: Post Comments (Atom). SQL Server codename...
sqlnz.blogspot.com
SQL Server Blog: October 2011
http://sqlnz.blogspot.com/2011_10_01_archive.html
Wednesday, October 19, 2011. Column-store indexes (Code Named Project Apollo). Normally SQL Server stores all of the data for a particular row together, Column store indexes store each column’s data together. The important thing to notice is that the columns are stored individually. If your queries are just doing. SELECT FirstName, LastName. It’s not perfect for everything, though: for starters, when you add a column store index to a table, that table instantly becomes. Monday, October 03, 2011. This blo...
sqlnz.blogspot.com
SQL Server Blog: November 2010
http://sqlnz.blogspot.com/2010_11_01_archive.html
Saturday, November 27, 2010. To download the latest CTP of SQL Server Denali click here. To view the latest Books online for SQL Server Denali click here. Labels: SQL Server Denali CTP. One cool feature that I have come across and now use is the Compound Assignment Operators in 2008. This new feature allows the combining of operators. So for example:. Declare@i integer = 5,. Set @i = 6 – Add and Assign. Select @i as [new value]. As you can see you can do the adding and assigning all on 1 line! Replicatio...
sqlnz.blogspot.com
SQL Server Blog: January 2013
http://sqlnz.blogspot.com/2013_01_01_archive.html
Monday, January 21, 2013. Show Database last access time. Here is a script that I use to get info of when a database has last been accessed without having to set up a trace. It gets it info from the DMV’s. So if there is a server restart then the info is gone. Get Last Restart time. Get last db access time (Null = no access since last reboot). Last user seek ). Last user seek )is. Last user scan ). Last user scan )is. Last user lookup ). Last user lookup ). Last user update ). Last user update ). Replica...