sqlserverconsulting.blogspot.com

SQL Server Stuff

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon. There is onl...

http://sqlserverconsulting.blogspot.com/

OVERVIEW OF sqlserverconsulting.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLSERVERCONSULTING.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 14 reviews

5 star

4

4 star

6

3 star

4

2 star

0

1 star

0

Hey there! Start your review of sqlserverconsulting.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.2 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLSERVERCONSULTING.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

173.194.46.106

LOAD TIME

0.25 sec

SCORE

6.2

PAGE TITLE

SQL Server Stuff | sqlserverconsulting.blogspot.com Reviews

<META> DESCRIPTION

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon. There is onl...

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 sql server stuff

4 kurt

5 posted by

6 no comments

7 enterprise edition

8 standard edition

9 new editions

10 1 comment

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,sql server stuff,kurt,posted by,no comments,enterprise edition,standard edition,new editions,1 comment,declare @cutoffdate datetime,days smallint;,name,type desc,create date,modify date,from sys objects,labels change control

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL Server Stuff | sqlserverconsulting.blogspot.com Reviews

https://sqlserverconsulting.blogspot.com

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon. There is onl...

INTERNAL PAGES

sqlserverconsulting.blogspot.com

1

SQL Server Stuff: January 2013

http://sqlserverconsulting.blogspot.com/2013_01_01_archive.html

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon.

2

SQL Server Stuff: December 2008

http://sqlserverconsulting.blogspot.com/2008_12_01_archive.html

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Tuesday, December 23, 2008. SQL 2008 cluster installer bug. I just got back from an on-site assignment in Denver. W were migrating to SQL. 2008 on a new set of Windows 2008 clustered servers and ran into an installer bug. We completed the install of the first node but the install failed for the second node because of an invalid product SKU. Was valid. It was slipstreamed. Microsoft is well aware of the bug and has a hotfix.

3

SQL Server Stuff: Smoke and Mirrors in SQL Server 2008 R2

http://sqlserverconsulting.blogspot.com/2010/03/smoke-and-mirrors-in-sql-server-2008-r2.html

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Tuesday, March 16, 2010. Smoke and Mirrors in SQL Server 2008 R2. Microsoft is touting its new Release 2 of SQL Server 2008. If they weren't planning to charge for it they would be honest and call it a service pack, not a Release. When you consider that SQL Reporting Services arrived in a free service pack for SQL 2000, what R2 offers as a full release is a bit underwhelming. For the Standard Edition user, there is even less tha...

4

SQL Server Stuff: July 2009

http://sqlserverconsulting.blogspot.com/2009_07_01_archive.html

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Saturday, July 11, 2009. TSQL change in SQL 2008 can break legacy code. Here is an example of the old syntax using the AdventureWorks sample database:. SELECT SalesTerritory.Name, SalesPerson.SalesPersonID. FROM Sales.SalesTerritory, SALES.SalesPerson. WHERE Sales.SalesPerson.TerritoryID *= Sales.SalesTerritory.TerritoryID. SELECT SalesTerritory.Name, SalesPerson.SalesPersonID. Sql server 2008 cluster invalid sku error. I am a l...

5

SQL Server Stuff: May 2009

http://sqlserverconsulting.blogspot.com/2009_05_01_archive.html

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Saturday, May 2, 2009. The Perils of XML Over-Use. Like all technologies, XML has its strong and weak points. It is useful in many situations. However it is often used in places where it is not appropriate. The performance cost of XML mis-use or over-use can be enormous. As well as having performance issues, both forms of xml take almost twice the disk space of relational data as can be seen the Storage column of the table above.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

sqlserverconsultant.co.uk

Home | INFOREXX

Capabilities & Expertise. Labs & Products. INFOREXX specialises in Data Analytics and BI delivery for financial services and insurance industry. Based on of 17 years of experience delivering amazing and innovative deliveries for transforming business data into actions and money. So far Dell, Microsoft, Allianz, Hitachi Consultancy, startup Dcisions and many other great brands have relied on our outstanding solutions delivered. Please check out more about story behind. Who is my typical client? Design dat...

sqlserverconsultant.net

Mr. Data: Database Consulting

SQL Server * MySQL * Oracle * Access * Any RDMS database. Database Programming (Stored Procdures). Data Driven Applications: Web, Mobile, Desktop. XML Web Services (ReST, SOAP). Database and Web Hosting. Cloud Services and Microsoft Azure. Custom Data Access Libraries. C#/NET, PHP, VB, ColdFusion, AJAX, JSON, jQuery. Is your data safe? Is your data secure? Feel free to call me at 678-522-3174 or email to mhonohan@hotmail.com.

sqlserverconsultants.info

SQL Server Consultants, LLC. - A network of SQL Server Consultants

SQL Server Consultants, LLC. Welcome to the Network of SQL Server Experts! We are a Dallas, Texas area based network of highly experienced SQL Server DBA's, Developers and Architects, who came together at various points in our careers. Experience of our network members ranges from 10 to more than 20 years in IT profession, primarily Microsoft SQL Server. SQL Server is our only business. L et us discuss you needs. Systems Reliability and Credibility . Do your systems meet their expectations? Are the data ...

sqlserverconsultants.net

This site is under development

This site is under development. This page indicates the webmaster has not uploaded a website to the server. For information on how to build or upload a site, please visit your web hosting company's site.

sqlserverconsultants.org

SQL Server Consultants, LLC. - A network of SQL Server Consultants

SQL Server Consultants, LLC. Welcome to the Network of SQL Server Experts! We are a Dallas, Texas area based network of highly experienced SQL Server DBA's, Developers and Architects, who came together at various points in our careers. Experience of our network members ranges from 10 to more than 20 years in IT profession, primarily Microsoft SQL Server. SQL Server is our only business. L et us discuss you needs. Systems Reliability and Credibility . Do your systems meet their expectations? Are the data ...

sqlserverconsulting.blogspot.com

SQL Server Stuff

Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon. There is onl...

sqlservercoolness.blogspot.com

SQL Server Coolness

I love SQL Server. As of Oct. 2010, I am also an MCITP:DBA for 2005! This is TSQL, SSIS, vbscript, and powershell code I've implemented. For professional SQL Server developers only. Tuesday, October 23, 2012. TSQL - Returning Random Numbers. Someone was updating a table with test data, and asked me how to fill a column with random numbers. I was sure rand() would do it. I was wrong:. It turns out that rand() generates only one number per statement, not per record. Boo. Crypt gen random (. You want to set...

sqlservercore.com

sqlservercorner.blogspot.com

SQL Server Administration

Monday, August 26, 2013. Login failed for user 'Admin' with SQL 18456 State 5. A client receives error when running MS Access application and querying tables linked via ODBC. The error is:. SQL Server Error: 53. SQL Server Error: 17. Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. What shows up in the SQL log is:. Login failed for user 'Admin'. [CLIENT: xx.xx.xx.xxx]. Error: 18456, Severity: 14, State: 5. Change from 1 to 0. Thursday, June 21, 2012. That's for 2 re...

sqlservercowboy.wordpress.com

SQLServerCowboy « Dedicated to my SQL Server and VMware Adventures

Virtualization – Hyper-V , VMware and SQL Server. Dedicated to my SQL Server and VMware Adventures. Virtualization – Hyper-V , VMware and SQL Server. Short Tutorials Concepts Simplified. September 17, 2013 4:16 pm. Continuing from my previous blog post about icons! We shall now delve into another helpful topic series –. This is not your regular e-books. They have been crafted in a very lucid manner. One of the two favorites is from @ Syncfusion. 8216;s ebook library are. Windows Store Apps Succinctly.

sqlservercurry.com

SQL Server Tutorials and Tips

August 08, 2015. Memory Optimized Tables and Transactions in SQL Server 2014. Saturday, August 08, 2015 Posted by Pravinkumar Dabade. Labels: SQL Server 2014. In one of our previous articles “ SQL Server 2014 – InMemory Table, Indexes and Stored Procedures. 8221;, we saw how to create in-memory tables and indexes. We also saw how to use stored procedures to interact with these tables. There are number of Isolation Levels supported by transactions as described below –. 183; Snapshot Isolation. 8211; In th...