thesqlguy.wordpress.com
The SQL Guy | by Norm Engerby Norm Enger (by Norm Enger)
http://thesqlguy.wordpress.com/
by Norm Enger (by Norm Enger)
http://thesqlguy.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
10
SSL
EXTERNAL LINKS
2
SITE IP
192.0.78.13
LOAD TIME
0.547 sec
SCORE
6.2
The SQL Guy | by Norm Enger | thesqlguy.wordpress.com Reviews
https://thesqlguy.wordpress.com
by Norm Enger (by Norm Enger)
thesqlguy.wordpress.com
Norm Enger | The SQL Guy
https://thesqlguy.wordpress.com/author/thesqlguy
Update to my “Robust Posh Script to Delete Files” Script. I have made a modification to my “Robust Posh Script to Delete Files” scripts so that they will only delete actual files in the specified path, and not folders. It does this by using the statement if ( Test-Path $ .fullname -pathtype leaf) to check whether the object being considered is a file. Is the link to the updated post and scripts. Posted February 2, 2016 by Norm Enger. In Microsoft SQL Server. I am back blogging for the New Year 2016!
Publishing Source Code to WordPress Using Windows Live Writer 2011 | The SQL Guy
https://thesqlguy.wordpress.com/2011/06/20/publishing-source-code-to-wordpress-using-windows-live-writer-2011
Publishing Source Code to WordPress Using Windows Live Writer 2011. My previous blog post Publishing Code Snippets on My WordPress Blog. Explained how I used a read-only textarea to publish source code. Alas, WordPress has started stripping out textarea tags when you publish to their site or edit existing posts. They explain that this is for security reasons at http:/ en.support.wordpress.com/code/. Please note that when you go back to the Edit view in Live Writer, the above sourcecode. When you publish,...
About | The SQL Guy
https://thesqlguy.wordpress.com/about
Welcome to “The SQL Guy” blog site! My name is Norm Enger,. 8220;the SQL guy”. I have worked in and around Microsoft SQL Server as well as web and other programming languages since 1997. I am by profession a Microsoft SQL Server database administrator (DBA), or as some of my friends and coworkers have called me over the years, “the database guy” or “the SQL guy.”. I am employed by Mohawk Industries. Of Dalton, GA, working remotely to my office from Tucson, AZ. Thanks for stopping by!
An Exceptions-Based Report for SQL Backups | The SQL Guy
https://thesqlguy.wordpress.com/2011/02/28/an-exceptions-based-report-for-sql-backups
An Exceptions-Based Report for SQL Backups. If you used an earlier version of the stored procedure, I have made a couple of minor corrections to the procedure below, including adding logic for including, in the all exceptions implementation, dbs in the BULK LOGGED recovery model, which were omitted before. In a follow-up post. Here is the script. To easily copy the code, hover your mouse over the below section and click the copy to clipboard button in the tool bar that appears at the top right. I...USE [...
The SQL Guy | by Norm Enger | Page 2
https://thesqlguy.wordpress.com/page/2
An Exceptions-Based Report for SQL Backups – Part 2. As promised, here is part 2 of of the blog An Exceptions-Based Report for SQL Backups. For the first blog). Using the attached Backups Exception Report.rdl. File as an example (click HERE. To download), you can create a nifty report. Based on the stored procedure in the first post. Click HERE. One of the most useful – well fantastic, really! Include the double quotes). Include the double quotes). You are ready to start using this report. Another enhanc...
TOTAL PAGES IN THIS WEBSITE
10
The SQL Geek | Ramblings of a SQL Geek
Ramblings of a SQL Geek. SSIS Package Configurations with SQL Encryption. SQL Server Row and Cell Level Security. Always On Capacity Calculator. AlwaysOn Availability Group Capacity Planning. On Always On Capacity Calculator. On Always On Capacity Calculator. On Always On Capacity Calculator. On Always On Capacity Calculator. On Always On Capacity Calculator. By The SQL Geek. May 23, 2015. Bull; 0 Comments. SSIS Package Configurations with SQL Encryption. By The SQL Geek. May 22, 2015. Bull; 0 Comments.
The SQL Goddess
The SQL Goth
Monday, September 19, 2016. SSRS: Change Text Color for Better Readability. When using a tool that is meant to visualize data, it helps to make the visualization pleasing to look at. Typically, this kind of discussion would spiral out of control into an abyss of SSRS techniques and theories about visualization, but I just want to share a quick tip when working with tables containing a lot of numbers. What I prefer to do, since there are so many 0’s throughout the table, is change the color to give ...
Logix Design Studios, LLC
We are what we repeatedly do. Excellence, therefore, is not an act, but a habit. Learn About our Team and Culture. Emsp; Logix Design is a creative studio that focuses on providing software solutions that help businesses grow and increase revenue in the online and mobile world. We help build brands by merging strategy, creativity and technology. We’re currently accepting new client projects. We look forward to serving you. Logix Design Studios, LLC. Lake Worth, FL 33467. 2015 Logix Design Studios, LLC.
The SqlGrrrl | Isabelle Van Campenhoudt >>> Performance matters Too
Isabelle Van Campenhoudt Performance matters Too. Accéder au contenu principal. PASS-ez l’info… retour du Summit 2014. La vie communautaire ca passe forcément par des échanges. Venez vite vous inscrire et poser vos questions A peine leur jetlag récupéré, plusieurs membres bien connus de la communauté SQL auront le […]. Lire l’Article →. SQL Saturday Paris 12 and 13 Septembre Demaaaaaaaaaaaaaandez le programme, C’est pour demain! Lire l’Article →. Lire l’Article →. Des questions et des réponses…. Malgré t...
The SQL Guy | by Norm Enger
Query to Display Recent Data and TLog File Autogrowth and Autoshrink Events. Here is a query to read the default trace on your SQL instance and produce a report of recent Data and TLog file autogrowth and autoshrink events that have occurred for that SQL instance. The query works for SQL 2005 and above, and there are no edits required. Here is the script. To easily copy the code, hover your mouse over the below section and click the copy to clipboard button in the tool bar that appears at the top rig...
Welcome to THESQLHOWTO.COM
Interested in this domain? Sorry, there are no results for your search. Search again:. This page is provided courtesy of GoDaddy.com, LLC.
The SQL Lounge | Anthony Coleman
Use DocxPress to Document Your Environment. Posted by Anthony Coleman. BixPress SSIS Unit Testing. Posted by Anthony Coleman. SSIS Unit Testing is an exciting new feature in BixPress that allows developers and users to ensure that a package is performing exactly the way that it was intended to. Today I will walk you through an example of how I used SSIS Unit Testing to take advantage of some of its cool features. In […]. Posted by Anthony Coleman. Posted by Anthony Coleman. SQL Anthony On Twitter. SQL wi...
The SQL Nomad - Have Database, Will Travel
Have Database, Will Travel. How To: Set Up Email Notifications for SQL Agent Jobs. Posted by Nomad on October 26, 2016. 8220;Before we hired you, I would check the job histories on the servers to make sure all the databases got backed up over the weekend,” my boss said, about week three into the job. Can you do that now? 8221; I told him I could do him one better: I could get the servers to tell…. How To: Backup SQL Server Databases to Azure. Posted by Nomad on October 13, 2016. Q: I went to change a col...
The SQL Post
Ashish Upadhyay's Blog : The SQL Post! Friday, January 9, 2015. SQL Server Error: Invalid use of schema or catalog for OLE DB provider "SQLNCLI11" for linked server "*". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. Recently I was building a new database infrastructure on SQL Server 2012 to run a third party application called Relativity. Connect to the SQL Server via SSMS (SQL Server Management Studio) and go to. Links to this post.
The SQL Pro | (Ayman El-Ghazali – www.thesqlpro.com)
Ayman El-Ghazali – www.thesqlpro.com). Code &Slides for Presentations. Arabic SQL Server Videos – تعليم باللغة العربية. Arabic SQL Server BI Videos – تعليم باللغة العربية. SQL Server FCI Virtual Lab. SQL Server Virtual Lab Section 1. SQL Server Virtual Lab Section 2. SQL Server Virtual Lab Section 3. SQL Server Installation Guide. Another Career Podcast – Working at Microsoft. I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean two podcasts recorded at one event! Last yea...
