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

http://sqlservercoolness.blogspot.com/

OVERVIEW OF sqlservercoolness.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

11

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLSERVERCOOLNESS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

April

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.5 out of 5 with 6 reviews

5 star

4

4 star

1

3 star

1

2 star

0

1 star

0

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.4 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLSERVERCOOLNESS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

11

SSL

EXTERNAL LINKS

0

SITE IP

173.194.46.107

LOAD TIME

0.359 sec

SCORE

6.2

PAGE TITLE

SQL Server Coolness | sqlservercoolness.blogspot.com Reviews

<META> DESCRIPTION

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

<META> KEYWORDS

1 sql server coolness

2 declare

3 tmptable table

4 id int

5 random float

6 intid int

7 while

8 intid

9 begin

10 insert

CONTENT

Page content here

KEYWORDS ON PAGE

sql server coolness,declare,tmptable table,id int,random float,intid int,while,intid,begin,insert,into,tmptable,values,intid =,update,tmptable set,random =,rand,select,from,lower int,upper int,tmptest table,random int,tmptest,tmptest set,cast,lower,upper

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL Server Coolness | sqlservercoolness.blogspot.com Reviews

https://sqlservercoolness.blogspot.com

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

INTERNAL PAGES

sqlservercoolness.blogspot.com

1

SQL Server Coolness: "Foreign key constraint" that references more than one table

http://sqlservercoolness.blogspot.com/2011/10/its-been-while-since-ive-blogged.html

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. Thursday, October 27, 2011. Foreign key constraint" that references more than one table. It's been a while since I've blogged something. I've just been busy! It will actually use a UDF and check constraints to mimic a foreign key constraint, but it will enforce referential integrity against more than one table. Users work for...

2

SQL Server Coolness: September 2010

http://sqlservercoolness.blogspot.com/2010_09_01_archive.html

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. Wednesday, September 1, 2010. TSQL - Automate DB restore. Automate restore w/o needing to know the logical file names. */. BEGIN - MODIFY THIS CODE - create a blank db. If not exists(select * from master.sys.databases where [name]='DBNAME'). END - MODIFY THIS CODE - create a blank db. Create table #tmpFilelist (. Filegroupid ...

3

SQL Server Coolness: June 2011

http://sqlservercoolness.blogspot.com/2011_06_01_archive.html

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. Friday, June 17, 2011. Run SSMS under a different domain account, or a SQL Server service account. Do you want a way to log in to your workstation, yet connect to your SQL Server instances using different domain accounts, too? I do this ALL the time. I use these commands CONSTANTLY in my workplace:. Subscribe to: Posts (Atom).

4

SQL Server Coolness: July 2012

http://sqlservercoolness.blogspot.com/2012_07_01_archive.html

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. Thursday, July 12, 2012. Add Description to Scheduled Task Using Powershell. You want to create a Scheduled Task? From the Scheduled Task GUI, it's simple. You want to do so from the Scheduled Task command line (schtasks.exe)? A bit more involved, but possible. Step 1. Set a variable to be the XML export file. Step 12. Yo...

5

SQL Server Coolness: November 2010

http://sqlservercoolness.blogspot.com/2010_11_01_archive.html

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. Wednesday, November 3, 2010. Windows Server 2008 and SQL Server 2008 - Database Mail Setup. I set up Database Mail on Windows Server 2008 and SQL Server 2008. It wasn't easy, so I hope this will help some of you. For Database Mail, you have to install IIS (why, Microsoft, why? Uncheck anonymous, uncheck basic, enable Integrat...

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL PAGES IN THIS WEBSITE

11

OTHER SITES

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

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