rodolforodarte.com
SQL Saturday 309 Slides are up. INTERSECT EXCEPT CROSS APPLY | Rudy Rodarte . com
http://www.rodolforodarte.com/2014/08/sql-saturday-309-slides-are-up
This article was written on 24 Aug 2014, and is filled under Programming. Current post is tagged. SQL Saturday 309 Slides are up. I had a great time speaking at SQL Saturday 309 in Oklahoma City. I look forward to making the drive again, if they’ll have me! In the mean time, here are my slides and files from the presentation:. Download from SQLSaturday.com. Download from RodolfoRodarte.com. If you have any questions, you can always contact me. Or send me tweet! Click here to cancel reply.
rodolforodarte.com
SQL Nexus Install | Rudy Rodarte . com
http://www.rodolforodarte.com/2014/09/sql-nexus-install
This article was written on 24 Sep 2014, and is filled under SQL Blogs. Current post is tagged. After attending Dev Connections 2014, I decided to try out SQL Nexus and PSSDiag again. I had used them several years ago, but the suite of tools, if you can call them that, were a bit clunky. After several years, I found that they are a bit better, but still clunky. Install in this order. From Microsoft. If you’re reading this, you probably already have .NET 4.0, but just in case. Report Viewer 2010 Hotfixes.
beenhazed.wordpress.com
October 2010 – Haze On Tech
https://beenhazed.wordpress.com/2010/10
B)logging my learning of SQL Server, Linux, technology, whatever. Find Indexes with Page Level Locking turned off on Database Server. October 20, 2010. Find Indexes with Page Level Locking turned off on Database Server. Clean Table with duplicate entries and add unique index. October 19, 2010. I would say that the title speaks for itself. Clean Table with duplicate entries and add unique index. The Baking DBA: SELECT * FROM Flour. Curricula Vitae (Résumé). My Résumé. Follow “Haze On Tech”.
beenhazed.wordpress.com
Generate MD5 Sum In SSIS Task – Haze On Tech
https://beenhazed.wordpress.com/2013/03/26/generate-md5-sum-in-ssis-task
B)logging my learning of SQL Server, Linux, technology, whatever. Generate MD5 Sum In SSIS Task. March 26, 2013. March 26, 2013. So, I wanted to have a built-in MD5 sum generator for a file that I have downloaded inside of SSIS. The code is below. Parsing Web Page for Link to Download in C# SSIS Script Task. A deadlock was detected while trying to lock variables. Leave a Reply Cancel reply. Enter your comment here. Please log in using one of these methods to post your comment:. Address never made public).
beenhazed.wordpress.com
July 2012 – Haze On Tech
https://beenhazed.wordpress.com/2012/07
B)logging my learning of SQL Server, Linux, technology, whatever. Inserting large datasets, a chunk at a time (Version 2). July 10, 2012. So I needed a simple and reliable way to loop on large datasets, and I had a version previously here, but it could have shifted my rownumbers around with using transaction in the loop. So, I rewrote it, and it works even better now. Usually, the times that I use this would be to replace… More Inserting large datasets, a chunk at a time (Version 2). My Résumé.
beenhazed.wordpress.com
November 2009 – Haze On Tech
https://beenhazed.wordpress.com/2009/11
B)logging my learning of SQL Server, Linux, technology, whatever. UPDATE with Table JOIN. November 24, 2009. So, I keep having to look this up, and it is driving me crazy. So, I decided to write about it, and have it in a place I can always reference it from. This is used only in situations where you have two different tables, need to perform an inner join, but the data is… More UPDATE with Table JOIN. UPDATE with Table JOIN. SQL Server Row Paging (LIMIT OFFSET). November 23, 2009. My Résumé.
beenhazed.wordpress.com
December 2009 – Haze On Tech
https://beenhazed.wordpress.com/2009/12
B)logging my learning of SQL Server, Linux, technology, whatever. Inserting large datasets, a chunk at a time. December 21, 2009. If you are like me, you hate loading large datasets into a production environment, only to cause the production system to be adversely effected, albeit brought down, because of a large dataset loading. So, I wrote up some T-SQL to handle this. I am sure other sites have better implementations of this, but I refer… More Inserting large datasets, a chunk at a time. Unable to Loc...
beenhazed.wordpress.com
February 2009 – Haze On Tech
https://beenhazed.wordpress.com/2009/02
B)logging my learning of SQL Server, Linux, technology, whatever. Handy Queries for Metadata Descriptions in SQL Server 2005. February 16, 2009. Handy Queries for Metadata Descriptions in SQL Server 2005. The Baking DBA: SELECT * FROM Flour. Curricula Vitae (Résumé). My Résumé. Create a free website or blog at WordPress.com. Follow “Haze On Tech”. Get every new post delivered to your Inbox. Build a website with WordPress.com.
beenhazed.wordpress.com
May 2009 – Haze On Tech
https://beenhazed.wordpress.com/2009/05
B)logging my learning of SQL Server, Linux, technology, whatever. Editing Red Hat Linux Message Queues Settings. May 15, 2009. From IBM InfoCenter In file /etc/sysctl.conf: kernel.msgmni=128 #Max # of msg queue identifiers kernel.msgmnb=163840 #Size of message queue kernel.msgmax=40960 #Max size of a message On Red Hat, the new settings are used after you restart the computer. To check that the new settings have been applied, issue the command sysctl -a. Editing Red Hat Linux Message Queues Settings.
beenhazed.wordpress.com
January 2009 – Haze On Tech
https://beenhazed.wordpress.com/2009/01
B)logging my learning of SQL Server, Linux, technology, whatever. Wondering what sql commands were executed. January 9, 2009. WARNING: This has probably been written many times before, but I am writing it for my own sake, and for anyone else who may never have thought of it before. So, I needed to know what SQL query was being executed in a stored procedure. But, I did not want to email it, and I… More Wondering what sql commands were executed. Wondering what sql commands were executed. January 8, 2009.