mikefal.net
presenting | Art of the DBA
http://www.mikefal.net/tag/presenting
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. T-SQL Tuesday #84: Getting Ready for your Presentation. Nov 8th, 2016. I’ve been super busy lately, but I wanted to at least post something for this month’s. How do we reduce or relieve some of this pressure? Well, let’s start with a list of things that could possibly go wrong when you present. Think about the following list:. You’re presenting and you get an on-call page. During your presentation,...
mikefal.net
Presentations | Art of the DBA
http://www.mikefal.net/presentations_page
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. An overview of implementing grants, denies, and database roles in SQL Server. Also included are useful auditing queries. Presentation (SQL Saturday 94). Server role audit.sql. Db roles audit.sql. Eating the Elephant – SQL Server Partitioning. An introduction to SQL Server partitioning, what it does, and how to make it work. 0-setup partition demos.sql. Tips and Tricks: MSDB BackupSet. MISSION. ...
mikefal.net
Fixing the #passvotes problem | Art of the DBA
http://www.mikefal.net/2014/09/29/fixing-the-passvotes-problem
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. Fixing the #passvotes problem. Sep 29th, 2014. Following up on my last post, it looks like PASS has addressed the election issues. The gist of the fix is:. The voting deadline has been extended to October 14. Members have until October 5 to update and validate your account. Go do this. My suggestions to PASS are:. Now that I’ve been burned by this, I will certainly pay more attention to how PASS is...
datasavvy.me
Community – Data Savvy
https://datasavvy.me/community
My experiences and education in data modeling, integration, transformation, analysis, and visualization. The SQL Server/MSBI Community has enriched my career through lots of learning and even job opportunities. Here are some of the ways that I have contributed to the community:. I’m the VP of Events for the Denver SQL User Group. I co-organized five SQL Saturdays: SQL Saturday Kansas City #s 159. I co-wrote a free e-book. About Datazen in 2015 after it was acquired by Microsoft. I am a Varigence. 8211; N...
sql303.com
SQL 303: Using SQLNCLI from SQL Server 2008 to 2005 can cause stack dump and service restart
http://www.sql303.com/2009/12/using-sqlncli-from-sql-server-2008-to.html
Colorado-based SQL Server DBA blog. Tuesday, December 22, 2009. Using SQLNCLI from SQL Server 2008 to 2005 can cause stack dump and service restart. I noticed recently when expanding the "Catalogs" folder under a linked server connection from a SQL Server 2008 server to a SQL Server 2005 server, that the 2008 server stack dumped and restarted the MSSQL service. Build 2600: Service Pack 3). Servers linked connection is made to):. Steps to recreate behavior:. The linked server connection itself works fine ...
sql303.com
SQL 303: December 2009
http://www.sql303.com/2009_12_01_archive.html
Colorado-based SQL Server DBA blog. Wednesday, December 23, 2009. Spinlock Issues, Unresponsive Servers, and TF2330. We have had a handful of servers go completely unresponsive for no apparent reason and even a DAC gets tied up after a minute or two. When we see this issue, we also notice the Application Event Viewer log is inundated with the following errors:. All with corresponding errors in the SQL log. When this issue arises, most of the time the SQL service will not stop, it simply hangs and times o...
mikefal.net
Speaking Updates - July 2015 | Art of the DBA
http://www.mikefal.net/2015/07/10/speaking-updates-july-2015
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. Speaking Updates – July 2015. Jul 10th, 2015. This is a short break from my usual blog posts to share some information on upcoming presentations I’m giving that might interest you. Performance Palooza – Virtual Performance Chapter. Coming up in two weeks (July 23), I’ll be part of the annual Performance Palooza. SQL SERVER BENCHMARKING: THE POWERSHELL SPEEDOMETER. Or SQL Saturday Denver. SQL Saturd...
mikefal.net
Checking Last Policy Based Management Execution | Art of the DBA
http://www.mikefal.net/2015/07/09/checking-last-policy-based-management-execution
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. Checking Last Policy Based Management Execution. Jul 9th, 2015. My current shop makes heavy use of PBM for alerting and monitoring our environment. For more on using PBM, check out stuff by John Sterrett. With PBM, it is very easy to know when a policy fails, but a lot more difficult to see exactly what has failed and why. Usually, the easiest way to see a failure is in SQL Server Management St...
mrandrewdykstra.wordpress.com
Mr. Andrew Dykstra | On SQL Server 'n Things | Page 2
https://mrandrewdykstra.wordpress.com/page/2
On SQL Server 'n Things. July 21, 2010. If you haven’t heard about it, there’s a spiffy new conference idea out there. Brent Ozar ( twitter. And Timothy Ford ( twitter. Came up with the brilliant idea of hosting a SQL Server training event on a cruise ship. They call it SQL Cruise. A cruise is relatively cheap, sessions can dive deeper and the class size can be smaller. I made it and I am absolutely stoked. What makes it possible is the price. The training is $295. If I can smuggle myself on boar...Oppor...
SOCIAL ENGAGEMENT