sirsql.net
SirSQL | SirSQL BlogSirSQL Blog
http://www.sirsql.net/
SirSQL Blog
http://www.sirsql.net/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
2.2 seconds
16x16
32x32
64x64
128x128
Dyn Inc
sirsql.net, Secret Registration Customer ID 332789 c/o sirsql.net
150 D●●●●●treet
Man●●●ter , NH, 03101
US
View this contact
Dyn Inc
sirsql.net, Secret Registration Customer ID 332789 c/o sirsql.net
150 D●●●●●treet
Man●●●ter , NH, 03101
US
View this contact
BUY YOUR DOMAIN
DYNAMIC NETWORK SERVICES, INC
WHOIS : whois.dyndns.com
REFERRED : http://www.dyn.com
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
48
SITE IP
67.225.208.62
LOAD TIME
2.212 sec
SCORE
6.2
SirSQL | SirSQL Blog | sirsql.net Reviews
https://sirsql.net
SirSQL Blog
sirsql.net
Installing | SirSQL
http://sirsql.net/content/tag/installing
All Tags & Categories. Enabling IFI on Setup in SQL Server 2016. SQL Server 2016 has added a couple of nice new options to the setup experience. First they added the ability to have multiple tempdb files on install, a nice time saver for later. And now, with CTP 3.0 they have added the ability to enable IFI on install. What is IFI, and how do I […]. Issues With Slipstreaming Service Pack 2 on to SQL 2008 R2. Be Careful Installing Windows Features. Subscribe to our e-mail newsletter to receive updates.
Backups | SirSQL
http://sirsql.net/content/tag/backups
All Tags & Categories. Tuning your backups is a wonderful thing. You could easily reduce the time it takes to backup your databases by 50% of more just by changing a few settings, and yet so few people do it. I asked myself the question why and came up with two answers. People do not know how to tune […]. Quickly Build Transaction Log Restore Commands With PowerShell. I’m in the middle of a server migration and so I’m setting up log shipping to get the databases consistent between the two ser...You can G...
SSIS Job Steps Failing Pending Execution | SirSQL
http://sirsql.net/content/2015/03/10/ssis-job-steps-fail-pending-execution
All Tags & Categories. SSIS Job Steps Failing Pending Execution. The other day a few SQL jobs were failing when attempting to execute SSIS packages. As usual a cryptic error was surfaced up to the job log “Execution Status: 5”. Great, really helpful. So I went to look at the package logs. Those actually didn’t show any failures, rather they just showed “Pending Execution”. At this point I knew it was going to be a long day. TL;DR; Version. Down In The Weeds. Declare @validation id bigint EXEC [SSISDB]...
AvailabilityGroups | SirSQL
http://sirsql.net/content/tag/availabilitygroups
All Tags & Categories. Availability Groups & Reindexing. I’ve been working with AGs for the last year and have a couple of things as regards indexing that I thought would be good to share: (more…). Improving Performance When Querying Multiple DMVs. Sp GetAGInformation – Updated. Gathering AG Information – sp GetAGInformation. The release of SQL 2012 brought about SQL Server AlwaysOn Availability Groups (AGs) as a new way to manage HA for databases. With AGs came a whole lot of new DMVs to give you in...
FusionIO and the Go Faster Button | SirSQL
http://sirsql.net/content/2015/02/12/fusionio-and-the-go-faster-button
All Tags & Categories. FusionIO and the Go Faster Button. Nobody has ever said that FusionIO cards were slow (because they aren’t). Especially if you compare their performance to regular spinning media, or high performance SANs. After all, no SAN will allow you to measure storage write latency in microseconds. Why Would My Card Be Slow? I wouldn’t say your card was slow, but there is potential that you could be getting a lot more from it than you do now. Up to 150W with optional power cords). The Fus...
TOTAL PAGES IN THIS WEBSITE
19
Azure |
https://newsqlblog.com/category/azure
HUGE SQL Azure Features in Preview Today. April 24, 2014. Earlier this month at the Build conference the news broke of major changes to Microsoft Azure SQL Database (a.k.a. the platform formerly known as Windows Azure SQL Database a.k.a. the platform formerly known as SQL Azure). This morning those changes were released as preview features. I’m going to go ahead and take credit for the two big ones, based on my comment in this Brent Ozar blog post. So, what’s new? Second, the maximum size of a database h...
PASS |
https://newsqlblog.com/category/pass
Speaking at #sqlsat145 and #sqlsat167. September 6, 2012. 8217; moments I love abound. One of my own ‘Ah ha! 8217; moments is another reason why I enjoy this presentation so much. At my first PASS Summit I went to Maciej Pilecki’s ( T. I’m extraordinarily fortunate to do what I do. And I’m looking forward to sharing some of the excitement I have about the amazing world of data and the tools we use with the sql family. Speaking at SQL Saturday #111. March 26, 2012. 8217; And make sure to follow the #sqlsa...
Azure |
https://newsqlblog.com/tag/azure
HUGE SQL Azure Features in Preview Today. April 24, 2014. Earlier this month at the Build conference the news broke of major changes to Microsoft Azure SQL Database (a.k.a. the platform formerly known as Windows Azure SQL Database a.k.a. the platform formerly known as SQL Azure). This morning those changes were released as preview features. I’m going to go ahead and take credit for the two big ones, based on my comment in this Brent Ozar blog post. So, what’s new? Second, the maximum size of a database h...
PowerShell |
https://newsqlblog.com/category/powershell
March 14, 2013. Over the years I’ve noticed certain characteristics in the IT professionals I respect the most. These range from the rather obvious intellectual curiosity that goes beyond all matters IT to the more subtle religious devotion to particular code formatting styles. The germane attribute to this post is that they also recognize. It was a step ahead of PowerGUI, but was a bit ‘clunky’. Idera makes some great tools and provide awesome support for the PowerShell community (they r...Also, their f...
PowerShell Concurrency |
https://newsqlblog.com/category/powershell/powershell-concurrency
Psasync Module: Multithreaded PowerShell. December 17, 2012. The series I did on Concurrency in PowerShell. Contains by far the most popular posts on my blog (getting tens of views every day! Particularly the one on using runspaces. The code demonstrated in the post was an early attempt at using the method. Not long after I refactored the functions I was using into something more modular and flexible. Thus, the psasync module. The module contains the following functions:. A handy function for working wit...
The Case of the Orphan Transactions |
https://newsqlblog.com/2013/07/31/the-case-of-the-orphan-transactions
HUGE SQL Azure Features in Preview Today →. The Case of the Orphan Transactions. July 31, 2013. I usually have trouble making it through long blog posts and this isn’t going to be short. But, this is quite a story and can’t be told quickly. Here’s the partial output from sp WhoIsActive:. Sysdm tran active transactions. This is interesting. There are 1,926 open transactions but there is only one in this DMV. So, for which one of those 1,926 transactions does this DMV report? Is no help. A bit of testi...
SQL Server 2016 | SQLSailor
https://sqlsailor.com/category/sql-server-2016
Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends! Category Archives: SQL Server 2016. AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016. June 29, 2016. Let’s look at a demo to demonstrate the new behaviour –. I have enabled Database Level Health Detection for my AG as shown below –. Now, in theory if one of the disks which is hosting my database tpcc. Is gone(both data/log file), then it should trigger a failover. I went ahead and inserted data contin...
Install | SQLSailor
https://sqlsailor.com/category/install
Personal Notes on Microsoft SQL Server,Microsoft Azure and Database Trends! SQL Server 2016 CTP 3 Setup – UI Improvements. November 11, 2015. There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters. My earlier post on setup UI changes for CTP 2 is available here. This was a surprise when I saw it for the 1st time :. There is an interesting post by Nic Cain( B. I’m re...
PowerShell | SQLvariations: SQL Server, a little PowerShell, maybe some Tableau
http://sqlvariant.com/tag/powershell
SQLvariations: SQL Server, a little PowerShell, maybe some Tableau. Maybe even the occasional ETL tidbit. Skip to Content ↓. SQL 2008 KB Articles. PowerShell Script to Download SQL MCM Videos. Next for the PoSh VC: PowerShell, SQL and Power BI. Aug 12th, 2016. That’s right, PowerShell and Power BI. How does this work you ask? Well back in July, Rob Sewell ( b. Gave us a preview of this, you can catch a few minutes here: https:/ youtu.be/rc6lwiTE9GI. 8220;Could you just tell me? In this session you will l...
SQL Server | SQLvariations: SQL Server, a little PowerShell, maybe some Tableau
http://sqlvariant.com/category/sql-server
SQLvariations: SQL Server, a little PowerShell, maybe some Tableau. Maybe even the occasional ETL tidbit. Skip to Content ↓. SQL 2008 KB Articles. PowerShell Script to Download SQL MCM Videos. Webinar on 25 New PowerShell cmdlets for SQL Server and more! Jun 30th, 2016. Next week Chrissy LeMaire. Laerte Junior ( b. Rob Sewell ( b. And I will be hosting a webinar covering the new PowerShell cmdlets that have just arrived. In the end-of-June update of SSMS 2016. You can register for the webinar here. ON qt...
TOTAL LINKS TO THIS WEBSITE
48
Untitled
SIRS Pro
NEXT GENERATION FINANCIAL MODELLING. SIRS - the smart way to analyse spreadsheets. Professionally programmed XLL-AddIn for fast and easy installation and secure usage. 1-Click Solution no training for creating reports necessary. Developed by Excel audit professionals. Incredibly fast – analyses 40.000 functions in 60 seconds. Professional report design for official regulatory use. Analyses the whole workbook – options, structure, functions, names, links, information workflow.
ProQuest - Online Research Tools for K-12 Schools & Libraries
Keep up to date with all of @ProQuest's recent news. Latest news within the industry. IThink interactive research tool.
sirspy - 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 13 Years. This deviant's activity is hidden. Deviant since Jun 11, 2002. This is the place where you can personalize your profile! By moving, adding and personalizing widgets. Why," you ask? Window...
Sir Spyro
UPCOMING EVENTS AND RESIDENCY. 1:00 am - 29 1:00 am. At An der Schillingbrücke 3, 10243 Berlin, Germany. Through My Speakers @ the YAAM - Germany Berlin. 28 (Friday) 1:00 am - 29 (Saturday) 1:00 am. An der Schillingbrücke 3, 10243 Berlin, Germany. New Website Coming Soon. Posted on August 1, 2013. Bull; 1 Comment. New website created by Diane Laidlaw of The Design Creative. Hope you like.
SirSQL | SirSQL Blog
ISNULL & Data Length Handling. Availability Groups & Reindexing. Life as a DevOps DBA. SSIS Job Steps Failing Pending Execution. FusionIO and the Go Faster Button. By William C. Dietz. By William C. Dietz. A Murder of Clones. By Kristine Kathryn Rusch. By William C. Dietz. By William C. Dietz. ISNULL & Data Length Handling. Something else to be careful of is managing queries where you might look at a value in one column, and if it’s a NULL, return the value from another. For example:. Life as a DevOps DBA.
Strategic Intelligence Research & Resourcing, Ltd | Leveraging organization decision making capacity with research and analysis
Strategic Intelligence Research and Resourcing. Leveraging organization decision making capacity with research and analysis. Mission Statement: Custom Research. The goal of SIR. Is to provide private and public sector clients with purposeful research and resourcing that will build institutional knowledge that will leverage the organizations decision making capacity. Economic and Market Assessments. Objective evaluation of the potential of a new product, new business idea or new investment.
Sir's Quarters - A site for Sirs
A site for Sirs. Aug, 11 - 2015. SARA JEAN UNDERWOOD, HOTTEST WOMEN ON THIS PLANET! Aug, 11 - 2015. A video posted by Live Rich Media (@liverichmedia). Aug 11, 2015 at 6:07pm PDT. SARA JEAN UNDERWOOD, HOTTEST WOMEN ON THIS PLANET! CDSR AND FRIEND RUNNING SOME FIRE ROADS. Aug, 11 - 2015. CDSR AND FRIEND RUNNING SOME FIRE ROADS. THE MOST AMAZING WATCH MOVEMENTS. Aug, 10 - 2015. THE MOST AMAZING WATCH MOVEMENTS. HOW MANY BONES HAS TRAVIS PASTRANA BROKEN. Aug, 07 - 2015. TRIALS RIDING IN THE SNOW. Sorry, you...
SirSqueeble (Whitesauce) - 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 4 Years. This deviant's full pageview. This is the place where you can personalize your profile! By moving, adding and personalizing widgets. You can drag and drop to rearrange. Why," you ask?
Official Web Page of Sir Squid
SirSquidness.com - Home of the Undersea World
You have reached SirSquidness.com. This is the personal website of SirSquidness, as seen in productions such as Respawn LAN. And hasn't-started-running-yet LAN Admins. A UDP broadcast forwarder for service discovery across broadcast domains. A HTML5 based L3DGEWorld. Arduino and Python implementations of L3DGEWorld libraries. PAX PC Freeplay Management - A NodeJS and HTML/Websocket/etc app to manage PCs and the people using them. Contact me to get the source. Please leave a message after the tone.
SOCIAL ENGAGEMENT