sqlinthewild.co.za
SQL in the WildA discussion on SQL Server
http://sqlinthewild.co.za/
A discussion on SQL Server
http://sqlinthewild.co.za/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.7 seconds
PAGES IN
THIS WEBSITE
22
SSL
EXTERNAL LINKS
322
SITE IP
198.58.82.124
LOAD TIME
0.734 sec
SCORE
6.2
SQL in the Wild | sqlinthewild.co.za Reviews
https://sqlinthewild.co.za
A discussion on SQL Server
sqlinthewild.co.za
On hiatus | SQL in the Wild
http://sqlinthewild.co.za/index.php/2011/09/06/on-hiatus
SQL in the Wild. A discussion on SQL Server. SQL in the Wild. I’m taking a break from blogging while I finish off my thesis. With the pile of outstanding things that need doing and the deadlines for them, something has to give, and I figure the blog is the least impact of the lot. Click to share on Twitter (Opens in new window). Click to share on Facebook (Opens in new window). Larr; Previous post. Next post →. 9 September 2011 at 12:06. 9 September 2011 at 15:28. Congrats and good luck! By Gregory Benfo...
2011 Book review | SQL in the Wild
http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review
SQL in the Wild. A discussion on SQL Server. SQL in the Wild. Another year over and much as I did last year, I’m going to briefly go over the books I read this last year. I will freely admit, very few of these could be considered ‘classic literature’, most is a mix of sci-fi, fantasy or adventure fiction. That’s just what I like to read. My choice for best books of the year:. First Lord’s Fury (Codex Alera). This is the climax of the Alera series and definitely the best of the bunch. Fast moving, ten...
SQL University: Advanced Indexing – Filtered Indexes | SQL in the Wild
http://sqlinthewild.co.za/index.php/2011/11/09/sql-university-advanced-indexing-filtered-indexes-2
SQL in the Wild. A discussion on SQL Server. SQL University: Advanced Indexing – Filtered Indexes. SQL in the Wild. SQL University: Advanced Indexing – Filtered Indexes. Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in SQL Server 2008 – filtered indexes. A simple example of a filtered index would be. CREATE NONCLUSTERED INDEX idx Example ON Account (AccountNumber) WHERE Active = 1;. There are two main uses of a filtered index:. This can be extended to v...
Reading Execution plans | SQL in the Wild
http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans
SQL in the Wild. A discussion on SQL Server. SQL in the Wild. One of the more common questions I get from colleagues is on how to read the execution plan that SQL produces. At first I found it quite a hard question to answer as no one really taught me how to read them. When I started with performance tuning I got a bit thrown in the deep end. Current articles in this series, in order of writing, are. Structure of an execution plan. Execution plans, estimated vs actual. Execution plans from Profiler.
Functions, IO statistics and the Execution plan | SQL in the Wild
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan
SQL in the Wild. A discussion on SQL Server. Functions, IO statistics and the Execution plan. SQL in the Wild. Functions, IO statistics and the Execution plan. I’m going to start with this fairly simple scalar function, created in the AdventureWorks database. Create function LineItemTotal(@ProductID int) returns money as begin declare @Total money select @Total = sum(LineTotal) from sales.SalesOrderDetail where productid = @ProductID return @Total end. Query 1, the one with the scalar function:. SQL Serv...
TOTAL PAGES IN THIS WEBSITE
22
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...
Coconuts? - hikayu ro
http://hikayurodxhe.livejournal.com/833.html
October 26th, 2009. I 'm a little of an old school geek, I prefer rock knives and bear teguments. So You Get on Angstrom Deserted Island With WiFi and you 're still on the clock at work. O.K., so not a really good situational exercising here, but allow 's roll with it; we 'll name it a. Who to pass this to? I 'm attending shotgun a trifle. First, somebody I pick on a good deal with these things, Gail Shaw. Next, permit 's see what Tim Mitchell. Holds in the Pail. The Binary Marble Totalizer.
brent ozar – IgnacioSalom.com
https://ignaciosalom.com/tag/brent-ozar
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. Have you checked your SQL Server CPU speed lately? Blog at Wo...
SQL Server 2008 performance dashboard and SQL Server 2012 performance dashboard – IgnacioSalom.com
https://ignaciosalom.com/2013/02/12/sql-server-2008-performance-dashboard-and-sql-server-2012-performance-dashboard
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. And http:/ sqlserverfinebuild.codeplex.com/wikipage? Fill in ...
cpu speed – IgnacioSalom.com
https://ignaciosalom.com/tag/cpu-speed
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. Have you checked your SQL Server CPU speed lately?
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...
TOTAL LINKS TO THIS WEBSITE
322
sqlinternalsviewer.com - This domain may be for sale!
Find the best information and most relevant links on all topics related to sqlinternalsviewer.com. This domain may be for sale!
SQL Server, SQL DBA, MSBI - Trainings, Placements, Job Support
SQL Server, SQL DBA and MSBI DW Instructor-Led (LIVE) Online and Classroom Trainings. Is an ISO Certified Trainining Organization and Microsoft Learning Partner (ID# 4338151) offering real-time, practical trainings exclusively on SQL Server Technologies including SQL Server Development ( SQL Dev. SQL Database Administration ( SQL DBA. Microsoft Business Intelligence and Datawarehousing ( MSBI. Courses. Register today for free demo. LIVE Server Access for Lab. SQL Server / T-SQL. SQL Server and T-SQL.
DEVintersection Conference - Microsoft Technology Event | DEVintersection.com
MGM Grand, Las Vegas, NV. Our earlybird giveaway expires in. Register Early for a "Workshop Package" and receive a choice of XBOX ONE, Surface 3 or Microsoft Band based on the package chosen. Get a Surface 3 when you register for one of the "Complete Package" options. Executive Vice President, Microsoft Cloud and Enterprise group. Corporate Vice President of Microsoft's Developer and Platform Evangelism (DPE) Group. Corporate Vice President of Microsoft Azure, Microsoft. Kimberly L. Tripp. The intersecti...
SQL Interview Questions and Answers
Just another WordPress site. Skip to primary content. Skip to secondary content. SQL Interview questions part 6. August 13, 2015. Q51: Why do users prefer integrity constraints over database triggers? A51: Integrity constraints are easier to define than database triggers hence users prefer integrity constraints over database triggers. Q52: Name the three vital parts of client server model. A52: The three vital parts of a client server model are:. A) Network / Communication software. A57: Event driven pro...
SQL in the City
Register now for SQL in the City 2015! Redgate SQL in the City. SQL Server Training the Redgate way. Visit the event website. Friday 16 October 2015. Visit the event website. Monday 26 October 2015. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website. Visit the event website.
SQL in the Wild
SQL in the Wild. A discussion on SQL Server. How not to do a Masters degree. Bull; Posted in Personal. On August 11th, 2015 by Gail •. There are many, many guides to successfully completing a post grad degree, so I am not going to add to them. Instead, this is a list of things, based on personal experience, that you can do to make it somewhere between very difficult and impossible to complete that Masters or Doctorate degree. Do the degree while holding down a full-time job. Blogging and writing are a gr...
SQLIOSIMParser - Home
Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). SQLIOSim is a tool written by CSS Engineer Bob Dorr. SQLIOSim is designed to validate disk I/O subsystem correctness. SQLIOSimPaser will parse the output of the file and will put it a readable and reusable format (csv, xml). It helps you to save time interpreting results. The Genesis of SQLIOSim Parser. Ads by Developer Media.
:: MWEB Business - Achieve the extraordinary ::
Home
Welcome to SQL IQ. This site will be used to demonstrate Office 365 capabilities:. Sample Industry RSS Feed. Search help and community. There is no recommended article for this page. Try searching help and community. This shouldn't take long. Cant find what you are looking for? Post your question to the Office 365 Community. Sorry, we couldnt find an answer. Post your question to the Office 365 Community. Sorry, the help service is down, but you can find answers at Office support.
SQL iQuery for IBM i
Your best choice for IBM i Db2 to JSON. IBM i SQL tool that allows you to create and run modern database queries using SQL and you can even repurpose your existing Query/400 queries for SQL. IQuery v4.0 - Focus on the Web and JSON - December 2016. Our customers have build entire websites using just SQL iQuery v4.0 along with HTML and JavaScript because iQuery can produce JSON. When you need something that you can start using immediately, SQL iQuery 4.0 is your best choice. Version 3.2 Available Now.
Loading...
SOCIAL ENGAGEMENT