
shaunjstuart.com
Shaun J Stuart - SQL Server DBAThoughts, tips, and opinions of a SQL Server DBA regarding Microsoft SQL Server and possibly other things
http://www.shaunjstuart.com/
Thoughts, tips, and opinions of a SQL Server DBA regarding Microsoft SQL Server and possibly other things
http://www.shaunjstuart.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
2.7 seconds
16x16
32x32
Domains By Proxy, LLC
Registration Private
Domain●●●●●●xy.com
14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309
Sco●●●ale , Arizona, 85260
United States
View this contact
Domains By Proxy, LLC
Registration Private
Domain●●●●●●xy.com
14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309
Sco●●●ale , Arizona, 85260
United States
View this contact
Domains By Proxy, LLC
Registration Private
Domain●●●●●●xy.com
14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309
Sco●●●ale , Arizona, 85260
United States
View this contact
15
YEARS
0
MONTHS
14
DAYS
GODADDY.COM, LLC
WHOIS : whois.godaddy.com
REFERRED : http://registrar.godaddy.com
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
25
SITE IP
173.201.146.1
LOAD TIME
2.703 sec
SCORE
6.2
Shaun J Stuart - SQL Server DBA | shaunjstuart.com Reviews
https://shaunjstuart.com
Thoughts, tips, and opinions of a SQL Server DBA regarding Microsoft SQL Server and possibly other things
Understanding Statisitcs In SQL Server | Shaun J Stuart
http://shaunjstuart.com/archive/2015/07/new-online-course-understanding-statistics-in-sql-server-2
Just another SQL Server weblog. About Shaun J. Stuart. New Online Course: Understanding Statistics In SQL Server. July 22, 2015. August 3, 2015. I’m pleased to announce my new online course is now up and available: Understanding Statistics in SQL Server. To sign up (or the coupon code BLOG15OFF. To get a 15% discount. Don’t forget my other courses are still available:. Microsoft SQL Server 101. For a 15% discount. Understanding Data Compression in SQL Server. For a 15% discount. For a 15% discount. On Vi...
Certification | Shaun J Stuart
http://shaunjstuart.com/archive/tag/certification
Just another SQL Server weblog. About Shaun J. Stuart. May 26, 2015. Last weekend, I passed the last test needed to upgrade my MCTS: SQL Server 2008 certification to the MCSA: SQL Server 2012 certification. I still need to take one more exam to upgrade my MCITP: Database Administrator 2008 to the MCSE: Data Platform certification. I’ll probably do this, but I’m not sure I’ll continue with […]. Posted in SQL Server. April 23, 2012. April 19, 2012. Posted in SQL 2012. My Path To Certification. On Removing ...
SQL Server | Shaun J Stuart
http://shaunjstuart.com/archive/category/sql-server
Just another SQL Server weblog. About Shaun J. Stuart. August 8, 2016. August 1, 2016. It’s a SQL Server best practice to have Auto Create Statistics enabled on your databases. When this is on, SQL Server will create statistics on single columns when it needs them. However if someone comes along later and adds an index, that auto-created statistic might not be needed any longer. The Potential Problem When an […]. Posted in SQL Server. The Case Of The Multi-Column Auto-Created Statistic. August 1, 2016.
SQL 2012 | Shaun J Stuart
http://shaunjstuart.com/archive/category/sql-server/sql-2012
Just another SQL Server weblog. About Shaun J. Stuart. Enabling Data Compression January 2016 Update. January 11, 2016. January 4, 2016. Reader Dick H. posted a comment on my last version of this script stating that he got an error when this was run against tables containing sparse columns. Data compression does not support tables with sparse columns, so they should be excluded from this process. I’ve modified this script to correct this. I don’t have […]. Posted in SQL 2008. November 3, 2015. It’s...
The Certification Shuffle | Shaun J Stuart
http://shaunjstuart.com/archive/2015/05/the-certification-shuffle
Just another SQL Server weblog. About Shaun J. Stuart. May 26, 2015. Last weekend, I passed the last test needed to upgrade my MCTS: SQL Server 2008. Certification to the MCSA: SQL Server 2012. Certification. I still need to take one more exam to upgrade my MCITP: Database Administrator 2008. To the MCSE: Data Platform. Certification. I’ll probably do this, but I’m not sure I’ll continue with Microsoft certifications after this. Here’s why:. The exam was updated with SQL 2014 topics. (See this. This is r...
TOTAL PAGES IN THIS WEBSITE
20
SqlSandwiches - Page 2
http://www.sqlsandwiches.com/page/2
Find failed SQL jobs with powershell. January 30, 2012. February 7, 2012. This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery ( blog. Did a nice session on powershell for n00bs and it got me thinking that I need to start posting some of my powershell stuff up here. Log on to server A. Open up management studio. Open up SQL Agent’s job. Order by last outcome. Rerun the jobs that failed. Repeat for servers B, C, D….and on. Let's set up the email stuff.
BI « sqlconcept.com
http://sqlconcept.com/category/bi
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
Baselining « sqlconcept.com
http://sqlconcept.com/category/baselining
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. SQL Server 2012 Full-Text search and XML Search - the Wiki project. Finally, here are some results from the Wiki project. After a few days of development, here is the accounting for the wiki project:. Desktop PC with 8Gb RAM, single home use HDD. SQL Server 2012, using XML and Full-Text search. The total amount of data to be imported: 39.2 GB. The rea...
Becoming a sponsor « sqlconcept.com
http://sqlconcept.com/becoming-a-sponsor
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. So far I have been keeping this site away from advertisement at any rate. And yes, the rate is high. I pay out of my pocket for:. My family and friends’ free time. However, I am open to suggestions. If you think that this site should get colored by advertisement – feel free to drop me a line. And make me an offer. Who knows, I might go for it.
My Articles « sqlconcept.com
http://sqlconcept.com/my-articles
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. HDDs, SSDs and Database Considerations. By Feodor Georgiev, 09 January 2013. In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work and looks into the considerations every DBA should have in mind when choosing / working with SSDs. Read more…. How come the Hourglass? As the volume of data increases...
Business Intelligence « sqlconcept.com
http://sqlconcept.com/category/business-intelligence
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
. . . Products . . . « sqlconcept.com
http://sqlconcept.com/products
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. If you like this site, you can buy me a cup of coffee by donating any amount (in USD). Paul Turley's blog.
. . . . . Tools . . . . . « sqlconcept.com
http://sqlconcept.com/tools
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. On this page you will find the tools developed by SQLConcept. So far the tools are distributed for free. The first tools is the DefaultTraceAudit. Which is currently owned by SQLService. For information and F.A.Q.’s about the DefaultTraceAudit. For screenshots of the DefaultTraceAudit. For downloads of the DefaultTraceAudit. Paul Turley's blog.
Data Science « sqlconcept.com
http://sqlconcept.com/category/data-science
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Statistical Learning and visualization courses. There are two great resources I found recently and I am going though them as we speak. The first one is a course on Statistical Learning, which can be accessed here. The second one is a course on visualization by using the ggvis package in R, which can be found here. And here is where we draw the line.
SQL Latency Meter « sqlconcept.com
http://sqlconcept.com/tools/sql-latency-meter
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. If you like this site, you can buy me a cup of coffee by donating any amount (in USD). Paul Turley's blog.
TOTAL LINKS TO THIS WEBSITE
25
Shaun Joyce
ShaunJoyce (Shaun Joyce) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) " class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 7 Years. 5 Month Core Membership. Daily Pageviews ». July 19, 1982. Last Visit: 3 weeks ago. This is the place where you can personalize your profile! By moving, adding and personalizing widgets.
Domain pending ICANN verification.
This domain name is pending ICANN verification. Welcome to shaunjoynson.com Domain name registered by 123Reg/Webfusion. Please be advised that as of the 1st January 2014 it has now become a mandatory requirement from the Internet Corporation for Assigned Name and Numbers (ICANN) that all ICANN accredited registrars verify the WHOIS contact information for all new domain registrations, domain transfers and registrant contact modifications. Why has this domain been suspended? If you have not received the v...
Home
Please sign our Guestbook. Select a song to listen to using the player below. Welcome to Shaun Joynt’s music website. After a successful debut CD launch on Saturday 20th September 2008, the word is out - fresh, vibrant, redemptive, proclamational, and diverse! This CD has something for everyone - a tango, the blues, rock, ballades, easy listening, and so much more. Not to mention the songs were written and the music inspired by an intimate relationship with God. To purchase a CD,.
shaunJphoto
Shaun J Stuart - SQL Server DBA
Just another SQL Server weblog. About Shaun J. Stuart. New Online Course: Understanding Statistics In SQL Server. July 22, 2015. August 3, 2015. I’m pleased to announce my new online course is now up and available: Understanding Statistics in SQL Server. To sign up (or the coupon code BLOG15OFF. To get a 15% discount. Don’t forget my other courses are still available:. Microsoft SQL Server 101. For a 15% discount. Understanding Data Compression in SQL Server. For a 15% discount. For a 15% discount. What ...
肥満で外来にいきました
life under the kaleidoscope
Life under the kaleidoscope. Anthropology. Student. Anime. Skate Pop-Punk. Toys. Art. Got nostalgic for the Wizarding World of Harry Potter so I made some butterbeer. HOW ADORABLE IS THIS KITTY. Not everything in Australia wants to kill you. This is Doodlebug, an orphaned wallaby who loves his teddy bear a whole damn lot. Photo by Gillian Abbott. San Fransokyo, Big Hero 6. This tribute to Hayao Miyazaki by dono. Is so amazingly beautiful. Sen to chihiro no kamikakushi. Howl no ugoku shiro. Page 1 of 259.
Shaun Juncal
August 11, 2015. Most people that I know love adventure. Read the Post Low Friction Adventure.
Shaun Jury - Publishing Design
Cambridge Legal Studies HSC. The Hidden History of Women’s Australian Rules Football. A Pictorial History of Australian Test Cricket. Australian Prisoners of War. Under the Southern Cross. Shadow of the Thylacine. Mathematics and Statistics 9 Workbook.
Home