patrickkeisler.com
Everyday SQLSaving DBAs time and effort in their everyday tasks.
http://www.patrickkeisler.com/
Saving DBAs time and effort in their everyday tasks.
http://www.patrickkeisler.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.3 seconds
16x16
32x32
Patrick Keisler
6307 ●●●●●NE DR
CHA●●●TTE , North Carolina, 28269
United States
View this contact
Patrick Keisler
6307 ●●●●●NE DR
CHA●●●TTE , North Carolina, 28269
United States
View this contact
Patrick Keisler
6307 ●●●●●NE DR
CHA●●●TTE , North Carolina, 28269
United States
View this contact
BUY YOUR DOMAIN
12
YEARS
6
MONTHS
28
DAYS
GODADDY.COM, LLC
WHOIS : whois.godaddy.com
REFERRED : http://registrar.godaddy.com
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
26
SITE IP
172.217.11.51
LOAD TIME
0.281 sec
SCORE
6.2
Everyday SQL | patrickkeisler.com Reviews
https://patrickkeisler.com
Saving DBAs time and effort in their everyday tasks.
Everyday SQL – Saving DBAs time and effort in their everyday tasks
Saving DBAs time and effort in their everyday tasks. Configuring the Azure SQL Database Firewall. Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet. That sounds super cool and easy to use. But wait, there’s one word I’d like to highlight in that first sentence: internet . Anyone with an internet connection could access your database. Now that’s no cool. So how does Microsoft keep your database safe? When defining the rules through the Azure...
patrickkeisler.com
Everyday SQL: March 2015
http://www.patrickkeisler.com/2015_03_01_archive.html
Tuesday, March 10, 2015. SQL Nexus Might Just Save Your Bacon. SQL Nexus does not require you to install anything on the server that you intend to monitor, but you will need to copy some data collector files to it. The collector files just run SQLDIAG and some other TSQL scripts to collect data from your monitored server. Below is a list of some of the data that is collected. Windows Performance Monitor counters. Windows event logs (system, application, and security logs). SQL Server trace events. The Da...
Everyday SQL: How to Use xp_dirtree to List All Files in a Folder
http://www.patrickkeisler.com/2012/11/how-to-use-xpdirtree-to-list-all-files.html
Tuesday, November 13, 2012. How to Use xp dirtree to List All Files in a Folder. Dec 31, 2012 - Be sure to read Part 2. Of this post discussing xp dirtree. Last week I blogged about how to use an undocumented stored procedures to create folders. This week we need to do the opposite. We need to get a list of all files from a subfolder in order to process them. In order to do that, we'll use another undocumented extended stored procedure; master.sys.xp dirtree. D: Backup TRON4 TEST2 MyDb1'. This example on...
Everyday SQL: How to Use xp_delete_file to Purge Old Backup Files
http://www.patrickkeisler.com/2012/11/how-to-use-xpdeletefile-to-purge-old.html
Wednesday, November 21, 2012. How to Use xp delete file to Purge Old Backup Files. Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp delete file to purge old backup files from a folder. This is stored procedure used by the maintenance plans to clean up old backup files, but it makes for a handy purge tool when creating your own backup scripts. Let's suppose we have a simple script (taken from a recent post on stackoverflow.com. Db cursor ;.
Everyday SQL: sp_PerformanceCounters
http://www.patrickkeisler.com/p/spperformancecounters.html
The page is dedicated to sp PerformanceCounters and any updates made to it. Please read my blog post. For details on what data it gathers and how it functions. A special thanks to Kevin Kline and the other authors for creating the poster that inspired my code. Http:/ www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf. The entire script can be downloaded from the resources page. Subscribe to: Posts (Atom). 169; 2015 Patrick Keisler. View my complete profile.
Everyday SQL: The Case of the NULL Query_Plan
http://www.patrickkeisler.com/2013/09/the-case-of-null-queryplan.html
Tuesday, September 3, 2013. The Case of the NULL Query Plan. As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at our disposal is the query execution plan cached in memory by SQL Server. Once we have the query plan, we can dissect what SQL Server is doing and hopefully find some places for improvement. Grabbing the actual XML query plan for a stored procedure from the cache is fairly easy using the following query. For the query plan? SELEC...
TOTAL PAGES IN THIS WEBSITE
20
Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking? - Wayne Sheffield
http://blog.waynesheffield.com/wayne/archive/2013/02/invitation-for-t-sql-tuesday-39-can-you-shell-what-the-posh-is-cooking
My blog about SQL Server. Search for SQL Saturday sessions by specified key phrase. How TCP Chimney Offloading Affects SQL Server. Advent of Code (20). SQL Crazy Train (3). Follow me on Google. SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert’s Voice in SQL Server). By Jason Brimhall, David Dye, Jonathon Gennick, Andy Roberts, Wayne Sheffield. SQL Server T-SQL Recipes. By Jason Brimhall, Jonathan Gennick, Wayne Sheffield. February 5, 2013. T-SQL Tuesday Party History. That I’m cur...
Links — Charlotte BI Group
http://charbigroup.com/links
Where we believe that learning can be fun! User groups in Charlotte:. Charlotte SQL Server User Group. Analytics and Big Data Society (ABD Society). Charlotte SharePoint User Group. Carolina IT Professionals Group (CITPG). Friends in Tech (fiTECH). Queen City DotNetNuke User Group. Carolina Girl Geek Dinners. Charlotte Hadoop Users Group. Charlotte Office 365 Meetup. Carolinas Tableau User Group. User groups near Charlotte:. Triad SQL BI User Group (Winston-Salem, NC). Greenville BI Group (Greenville, SC).
TOTAL LINKS TO THIS WEBSITE
26
Web Hosting - This site is temporarily unavailable
Http:/ www.fatcow.com/. Http:/ www.fatcow.com/free-icons. Http:/ www.fatcow.com/free-font. Something isn't quite right here . This site is temporarily unavailable. If you're the owner of this website,. Please contact FatCow Web Hosting.
Sporting Keen Guns
Patrick Keesey Furniture & Design, NYC & Marfa
Patrick Kehoe // Still & Motion Pictures
Patrick Keilty
Patrick Keilty is Assistant Professor in the Faculty of Information. At the University of Toronto. Professor Keilty's primary research interest is the politics of digital infrastructures in the online pornography industry. His work spans issues in visual culture, sexual politics, technology studies, media studies, information studies, critical algorithm studies, political economy, database logic, critical theory, and theories of gender, sexuality, and race. Keilty is cross-appointed with the Cinema Studi...
Everyday SQL
Tuesday, January 2, 2018. SQL Server Morning Health Checks. Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer. One such occasion happened just recently when I was asked to help find a way to automate the daily checks the DBA had to perform every morning. The result was a PowerShell script that reduced that manual task down from an hour to less than a minute. You can read the full article here on MSDN. The PowerShell script can be downloaded from here. As you...
Patrick Keith
News and random musings from the Sculptdude. Sunday, October 22, 2017. Why We Bought a House and Tore It Down. Because many of you have asked how it's going with the property here is a brief overview. At first we looked at property in the mid-west, like Missouri, having a better proximity to attend shows and conventions, with an ideal climate. Later we determined this wasn't as practical and decided to stay in Texas near to family. LeeAnn Kearney - Realtor. We finally found a suitable site. At a price th...
Home Page
Keith Porter is an award winning journalist who now serves as president of the Stanley Foundation. He spent many years as the co-host and producer of the nationally syndicated public radio program on world affairs " Common Ground. As well as several public radio documentaries. He also served as a guide to world news, globalization, and U.S. foreign policy for About.com. He writes about "Meet The Press" at the blog If It's Sunday. All views expressed here are mine and cannot be attributed to my employer.
PATRICK K STACEY MUSIC | SONGS | COMPOSER | ACADEMIC | SCHOLAR | ARRANGER | PRODUCER | UK | Alternative | Rock | Dance | New Age | Piano | Guitar | Vocals | Emotion | University | Research
Email me: hello@patrickkeithstacey.com. Site under construction by digital bricklayers.
Patrick Keith Williams
Who is Patrick Keith Williams? Design by SKT Themes. Patrick Keith Williams, Owner of Cessna. Patrick Keith Williams, Charter Pilot. Patrick Keith Williams, Certified Flight Instructor. Patrick Keith Williams, Life Long Friend. Grab a Quick Copy of my vCard. Sorry, photo gallery is empty. Bucket List Why Wait To Get Started On Yours : Life Long Dream To Take A Private Jet. Feb, 26, 2018. Bucket List. Why Wait? Welcome To Patrick Keith Williams Dot Com. Dec, 28, 2017. 8211; $5,000. 8211; $5,000.
thuispagina - Fotografie van Patrick Keizer - de ketchupmaker
Deze site is onderdeel van ketchup media. Bel 31 (0)114 635 157, mail. Of stuur een brief naar: Oude Kaai 16 - 4569 AB Graauw.
SOCIAL ENGAGEMENT