sqlsanctum.wordpress.com
SQL Sanctum | A Join on SQL And Everything ElseA Join on SQL And Everything Else
http://sqlsanctum.wordpress.com/
A Join on SQL And Everything Else
http://sqlsanctum.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
3.8 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
7
SSL
EXTERNAL LINKS
23
SITE IP
192.0.78.12
LOAD TIME
3.783 sec
SCORE
6.2
SQL Sanctum | A Join on SQL And Everything Else | sqlsanctum.wordpress.com Reviews
https://sqlsanctum.wordpress.com
A Join on SQL And Everything Else
Automatic Tempdb Configuration Script | SQL Sanctum
https://sqlsanctum.wordpress.com/2015/08/14/automatic-tempdb-configuration-script
A Join on SQL And Everything Else. Skip to primary content. Automatic Tempdb Configuration Script. August 14, 2015. The default configuration for TempDb leaves a lot to be desired, and although good changes are on the way in 2016. It will be quite some time before any of us get to use that in production. If you hate reading. This script is meant to run against a new server that has the default settings in place for Tempdb, with a single data and log file. The script will rename those files per your i...
SQL Sanctum | A Join on SQL And Everything Else | Page 2
https://sqlsanctum.wordpress.com/page/2
A Join on SQL And Everything Else. Skip to primary content. Skip to secondary content. Newer posts →. SQL Server Troubleshooting: Token-based Login Failure. July 13, 2016. In continuation of the forced mirroring failover. Procedure I posted last week, this post describes the another level of pain you may encounter. After forcibly failing a mirroring session to the secondary server, users were unable to connect to the SQL Server. The SQL Error Log was full of the same error message. Login failed for user.
Querying Memory Settings | SQL Sanctum
https://sqlsanctum.wordpress.com/2015/06/03/reporting-memory-settings
A Join on SQL And Everything Else. Skip to primary content. June 3, 2015. SQL settings should be verified on a regular basis, and I’m occasionally asked to produce a list of memory configuration settings on all servers for management. It’s a simple process to check this information using Management Studio, but scripting is a much better solution, especially if you need to verify the settings on a large number of servers. Sysdm os sys memory. Will provide the information you need, but the results leave a ...
sqlsanctum | SQL Sanctum
https://sqlsanctum.wordpress.com/author/sqlsanctum
A Join on SQL And Everything Else. Skip to primary content. Skip to secondary content. Get and Set Folder Permissions with PowerShell. October 19, 2016. Managing permissions for numerous servers is the theme today. Drilling down into a folder, right-clicking properties, then reviewing security on the same folder for potentially dozens of computers is time consuming and, with the capabilities of scripting, unnecessary. Now for a simple example. Remember to supply a. Now that you have verified the permissi...
T-SQL Tuesday #66: Monitoring with Utility Explorer | SQL Sanctum
https://sqlsanctum.wordpress.com/2015/05/12/t-sql-tuesday-66-monitoring-with-utility-explorer
A Join on SQL And Everything Else. Skip to primary content. T-SQL Tuesday #66: Monitoring with Utility Explorer. May 12, 2015. This month’s topic for T-SQL Tuesday is hosted by Cathrine Wilhelmsen ( blog. With the subject of monitoring. The topic of the month is. Do you use T-SQL or PowerShell scripts? Have you created your own monitoring reports or applications? Have you invested in a complete monitoring solution from a vendor? What is monitored manually and what is automated with alerts? Unlike a CMS t...
TOTAL PAGES IN THIS WEBSITE
7
Is a Deprecated feature making my job more difficult? | Padre's SQL Resort
https://sqlpadre.wordpress.com/2015/05/20/is-a-deprecated-feature-making-my-job-more-difficult
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Larr; MCSA: SQL 2008. SQL Development Tools–I need what version? Is a Deprecated feature making my job more difficult? Posted by SQL Padre. Microsoft is notorious for changing and/or removing features in every version of SQL! Beginning in SQL 2012 two new features were debuted to replace FMTONLY setting.
SQL Padre | Padre's SQL Resort
https://sqlpadre.wordpress.com/author/olepadre
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Author Archives: SQL Padre. Ldquo;Stretching” my SQL Skills. Posted by SQL Padre. Philosophy has always intrigued me and René Descartes is one of my personal favorite philosophers. I began by right clicking on my [StretchTest] database and selecting TASKS STRETCH ENABLE. Then you get the customary SQL Summary...
SQL Development Tools–I need what version? | Padre's SQL Resort
https://sqlpadre.wordpress.com/2015/05/29/sql-development-toolsi-need-what-version
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Larr; Is a Deprecated feature making my job more difficult? 8 Weeks of Indexes–Structure of an Index →. SQL Development Tools–I need what version? Posted by SQL Padre. My shop primarily uses SSIS and SSRS with our SQL Servers so that is all I am confident with. SSRS 2005 — BIDS 2005 (Visual Studio 8). SSIS 20...
Favorite Stuff | Padre's SQL Resort
https://sqlpadre.wordpress.com/favs
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Here you will find some of my favorite scripts, code, and ramblings! Need a hosting company? Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. Voice of the DBA.
8 Weeks of Indexes–Structure of an Index | Padre's SQL Resort
https://sqlpadre.wordpress.com/2015/07/29/8-weeks-of-indexesstructure-of-an-index
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Larr; SQL Development Tools–I need what version? SQL Login / Agent Jobs Ownership SNAFU →. 8 Weeks of Indexes–Structure of an Index. Posted by SQL Padre. This is the 4th post in my series of 8 Weeks of Indexes. The Following table will be used to demonstrate my examples. With creating a non clustered index...
Invitation to T-SQL Tuesday #68: Just Say No to Defaults | Every Byte Counts
https://sqlbek.wordpress.com/2015/07/06/invitation-to-t-sql-tuesday-68-just-say-no-to-defaults
Invitation to T-SQL Tuesday #68: Just Say No to Defaults. Posted by Andy (@SQLBek). Asymp; 30 Comments. Welcome to another edition of T-SQL Tuesday! Started by Adam Machanic ( b. This is the SQL Server community’s monthly blog party, where everyone is invited to write about a common topic. And don’t think this month’s topic is constrained to just the SQL Server engine. SSIS and SSAS are absolutely fair game as well. SQL Server developer tools – sure! Deep dive and blog about that! Larr; Previous post.
Free Scripts | SQL Studies
https://sqlstudies.com/free-scripts
Skip to main content. Skip to secondary content. Live, Learn, Share. Study and Reference Materials. Here is a list of some of the most popular (and useful) free scripts and queries I’ve seen around the interweb. There are lot’s more and I’ll be adding them as I’m reminded of them. These guys seem to be putting out a script a week these days but they are still some of the highest quality and amazingly useful. They are now open sourced. A general health check of your instance. Troubleshoot your slow server.
MCSA: SQL 2008 | Padre's SQL Resort
https://sqlpadre.wordpress.com/2015/05/12/mcsa-sql-2008
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Larr; Learning about Licensing. Is a Deprecated feature making my job more difficult? Posted by SQL Padre. After a couple of tries (finding time to study is harder than I thought), I have finally passed my 70-432 to earn my Microsoft Certified Solutions Associate SQL 2008! Now, I must crack down! Notify me of...
TSQL Tuesday #63 – How do you manage security? | SQL Studies
https://sqlstudies.com/2015/02/03/tsql-tuesday-63-how-do-you-manage-security
Skip to main content. Skip to secondary content. Live, Learn, Share. Study and Reference Materials. TSQL Tuesday #63 – How do you manage security? February 3, 2015. You’re the next contestant on T-SQL Tuesday! What’s the best security design? You’ve picked up a legacy system and the security is awful, how do you fix it? Any great tools out there you’d like to share? Hate it or love it I’m betting we all have something to say. What is T-SQL Tuesday. Oh, well, you have one week to write your blog and then ...
Padre’s Tools for the DBA | Padre's SQL Resort
https://sqlpadre.wordpress.com/my-sql-toolbox
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Padre's SQL Resort. Inside the mind of a MS SQL DBA (it's scary in there). Padre’s Tools for the DBA. Padre’s T-SQL Scripts. Padre’s Tools for the DBA. These are some of the things that are in my SQL Toolbox (in no particular order). Most are free and some are available for a small fee:. Padre’s T-SQL Scripts. These are the scripts I use the most. Technically not free, but it is the BEST $96 dollars I have spent for any SQL tool!
TOTAL LINKS TO THIS WEBSITE
23
SQLSailor | Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends !
Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends! Why I won’t be running SQL Server Standard Edition on Business Critical Servers! July 9, 2015. I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a need to install Enterprise edition for business critical systems.Here are my top features which are missing in standard edition –. Memory Standard only supports 128 GB memory. Online page and file restore. Database size is...
Sqlsalt.com
This domain has recently been listed in the marketplace. Please click here to inquire.
Sql samples, sql tips
Sql samples, sql tips. Sql server 2000 2005 2008 2008R2, 2012 samples, tips, books, sharing. Sunday, November 10, 2013. Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383] [SQL server issues]. Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]. Wrote Feb 23, 2012 at 10:47 AM. Is this been taken care? Wrote Feb 26, 2012 at 5:21 AM. The attached script will fix the problem. Use the stored procedure to extend to future dates if needed. Labels: Created...
Sample Geo Data for SQL 2008 - Home
Project Hosting for Open Source Software. Sample Geo Data for SQL 2008. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). SQL Server 2008 R2 database backup with tables, containing sample geographic data, such as shapes/boundaries of Countries of the World, Territories and Provinces. The data was obtained from http:/ www.naturalearthdata.com/. 1:10,000,000 shapes and comes under their respective terms of use.
SQL SAMSON | everything sql
SSMS Copy Column Headers. Leave a comment ». Needing some sort of variation or at least a break from my certification studies I decided to revisit a title I purchased a while back: “ Beginning SQL Server 2008 for Developers. 8221; from @Apress written by Robin Dewson. Well not any more because page 42-43 of this awesome book had life changing screenshots of the Options dialog. Big deal right? Well a big deal for me at least! What you need to do is:. Step 1 – Go to Tools – Options. Just a side note, if yo...
SQL Sanctum | A Join on SQL And Everything Else
A Join on SQL And Everything Else. Skip to primary content. Skip to secondary content. Automatic Tempdb Configuration Script. August 14, 2015. The default configuration for TempDb leaves a lot to be desired, and although good changes are on the way in 2016. It will be quite some time before any of us get to use that in production. If you hate reading. This script is meant to run against a new server that has the default settings in place for Tempdb, with a single data and log file. The script will re...
SqlSandwiches
T-SQL Tuesday – SQL Family and community. August 12, 2014. This month’s T-SQL Tuesday is being hosted by Jeffrey Verheul ( B. Our topic of the month is SQL Family. Check out the host page here. Here is our task:. 8221; How do you feel about SQL Family? Did they help you, or did you help someone in the SQL Family? When I first started learning about databases, I lived on sites like SQL Server Central. Did you sign up yet? T-SQL Tuesday – Assumptions. July 8, 2014. I work for a vendor and our application(s...
Your Temporary Index
This is your temporary index.html file. Replace this file with your own index.html file. Upload your site files to the web server with the following software:. FTP Voyager 9.1. Create graphics and images for your web site with the following software:. Adobe Photoshop 7.0. Software you can build your site with:. Adobe Go Live 6.0. Books about web site design and development can be found at:. Barnes and Noble.com.
SQL Server Sarah
The daily adventures of a DBA. Friday, January 20, 2012. I am excited to announce that I will be speaking this Thursday at the Louisville SQL Server User Group meeting on the New Features of SQL Server 2012. The User Group meets at 5:30pm at the Duthie Center for Engineering at the University of Louisville. I also have 2 upcoming SSWUG events. The 4-Hour DBA: Automate, Audit and Relax. I will also be a part of a Security Expo on Feb 17th. I don't have a link yet, but when I do I will let you know. This p...
SerendipITy-Now.com
Serendipity's implementation services are provided with an emphasis on guidance to the customer to help enable self-reliance beyond the implementation. Contact us to learn more about ServiceNow implmentation, enhancement, and support. Serendipity can assist with your user training requirements. We "train the trainer", provide virtual training, and more. Ask about the customized training options currently available. ServiceNow Implementation, Enhancement and Support.
sqlsaturday-377-precon-benjamin-nevarez.ticketforevent.com
Tickets to "SQLSaturday Kiev 2015 PreCon. Benjamin Nevarez. SQL Server Query Tuning & Optimization" 22 May 2015 (Ukraine, Kiev)
Please select the number of tickets you want to order. Please select the number of tickets you want to order. Tickets for "SQLSaturday Kiev 2015 PreCon. Benjamin Nevarez. SQL Server Query Tuning and Optimization" (05/22/2015 – 05/22/2015). Ticket sales have ended on 22 May 2015 13:00. SQL Server Query Tuning and Optimization. Understand how the query optimizer works. Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools.
SOCIAL ENGAGEMENT