sqlservercore.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

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...

sqlserverdah.blogspot.com

SQL Server - Dah

SQL Server - Dah. Wednesday, April 15, 2009. SSIS: from Flat File Source to OLE DB destionation, everyday problems. And Invalid character value for cast specification. Let’s, first, fight the truncation problem. So, I have a simple flat file TEST1.txt:. The file has 4 rows; the 1st row contains the field names; the “” symbol is a field separator; carriage return is a row separator; there are no values in row 3, column ‘BBB’, and no value in row 4, column ‘AAA’. And same for a column “BBB”). Error: 0xC020...

sqlserverdaily.blogspot.com

My daily SQL Server blog

My daily SQL Server blog. Thursday, January 10, 2008. January 10, 2008. Could not locate text information records for the column "SUBJECT", ID 9 during command construction. Source: MSSQLServer, Error number: 18773). The Log Reader Agent failed to construct a replicated command from log sequence number (LSN) {0001af22:0003gwae:002a}. Back up the publication database and contact Customer Support Services. (Source: MSSQLServer, Error number: 18805). Http:/ support.microsoft.com/kb/933519. January 8, 2008.