News in the Category:
SQL 
Total posts: 5427 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, February 10, 2012
Views: 183 | Hits 7
It seems that we all love to solve puzzles. On SQLAuthority Page, we have been playing the number game and those who are playing with us know how much fun we are having. Sometimes, the answers are so ...
SQL Server DBA, February 9, 2012
Views: 322 | Hits 10
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The Microsoft web site has a search feature to return the late...
Journey to SQL Authority with Pinal Dave, February 9, 2012
Views: 627 | Hits 14
I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find ...
SQL Server DBA, February 8, 2012
Views: 172 | Hits 6
This message appears in the TDP SQL dsmsched file. Its usually associated with low levels of contiguous memoryBackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'TD...
Journey to SQL Authority with Pinal Dave, February 8, 2012
Views: 307 | Hits 12
SQL Server is ocean of information.. I believe if one starts learning today after 60 years he/she may be still learning the subject (there are always few exceptions)! Recently I published SQL Server Q...
SQL Server DBA, February 7, 2012
Views: 234 | Hits 12
This post describes how to call to add an email attachment using Powershell.
In an earlier post - SQL Server Send email using Powershell the new-object Net.Mail.SmtpClient() Class was us...
Journey to SQL Authority with Pinal Dave, February 7, 2012
Views: 273 | Hits 6
Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install al...
SQL Server DBA, February 6, 2012
Views: 340 | Hits 15
This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to a HTML file.
It is only one extra step to send this file as an attachment.
The ...
Journey to SQL Authority with Pinal Dave, February 6, 2012
Views: 239 | Hits 8
Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the who...
The Code Project Latest Articles, February 5, 2012
Views: 272 | Hits 14
Reproducing the SQL RAND() function in C#...
Journey to SQL Authority with Pinal Dave, February 5, 2012
Views: 182 | Hits 5
SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data prote...
SQL Server DBA, February 4, 2012
Views: 248 | Hits 9
This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.The Get-ItemProperty Cmdlet gets the properties of a specific item.In ...
Journey to SQL Authority with Pinal Dave, February 4, 2012
Views: 303 | Hits 3
I recently received email from one of my very close friend from California. His question was very interesting. He wanted to know how many virtual processors are there available for SQL Server. He alre...
Simple Talk, February 3, 2012
Views: 40 | Hits 1
In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases, Phil Factor demonstrates how one can generate TSQL scripts for databases, selec...
The Code Project Latest Articles, February 3, 2012
Views: 258 | Hits 14
SQLCMD can be used to login to the Sql Server as well. One can only provide Server address, User Name and Password at the command prompt and press enter.The command prompt will change to 1>. Now any s...
The Code Project Latest Articles, February 3, 2012
Views: 251 | Hits 28
A static method that returns a SqlCommand object with all the parameters for a specific stored procedure...
The Code Project Latest Articles, February 3, 2012
Views: 246 | Hits 19
How to get Client IP Address in SQL Server...
Journey to SQL Authority with Pinal Dave, February 3, 2012
Views: 173 | Hits 1
We have recently wrapped up our most recent event, SQL Saturday #116, and I am I am sure I am not alone in reporting that it was a huge success! We had a full crowd every seat taken, plus standing-ro...
SQL Server DBA, February 2, 2012
Views: 376 | Hits 14
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/***...
Steven Smith, February 2, 2012
Views: 246 | Hits 4
I’ve been working with Azure off and on since last summer, and like any new API or platform, there are hurdles involved with the learning curve. This is especially true for pre-release sof...
Steven Smith, February 2, 2012
Views: 254 | Hits 16
When we last saw our hero, he had fallen victim to an evil plot to disable his computer’s ability to boot up. After great efforts at recovery, eventually he was forced to concede defeat to...
Journey to SQL Authority with Pinal Dave, February 2, 2012
Views: 164 | Hits 4
Nov 3, 2011 – Visit to Grandma When ourSQL Server Interview Questions and Answersbook got published I ran to mygrandmawith a copy of the book for her blessings. Well, just like every grandma, she love...
DBA DB2, February 1, 2012
Views: 187 | Hits 1
You can look up any error message from the command line with ""db2 ? sqlxxxx"" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long)You can also use db2 ? SQLxxxx | moreT...
Journey to SQL Authority with Pinal Dave, February 1, 2012
Views: 199 | Hits 1
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 31, 2012
Views: 221 | Hits 9
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the Smtp...
Journey to SQL Authority with Pinal Dave, January 31, 2012
Views: 274 | Hits 2
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
Simple Talk, January 30, 2012
Views: 100 | Hits 5
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from havi...
Simple Talk, January 30, 2012
Views: 207 | Hits 9
Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down to different configuration setti...
DBA DB2, January 30, 2012
Views: 195 | Hits
I received the following error , when attempting to connect to a DB2 databasedb2 connect to MYDB
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030
#Checked in the db2diag...
SQL Server DBA, January 30, 2012
Views: 201 | Hits 7
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.Msg 245, Sev 16, State 1, Line 17 : Conversion failed when converting the nvarchar value '??u? ? ? ?AA?????...
Journey to SQL Authority with Pinal Dave, January 30, 2012
Views: 226 | Hits 2
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
Journey to SQL Authority with Pinal Dave, January 29, 2012
Views: 453 | Hits 10
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
Journey to SQL Authority with Pinal Dave, January 28, 2012
Views: 277 | Hits 7
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 27, 2012
Views: 265 | Hits 35
Generate SQL Server INSERT statements with Excel Concatenate.A developer requested access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then...
Journey to SQL Authority with Pinal Dave, January 27, 2012
Views: 340 | Hits 5
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 26, 2012
Views: 207 | Hits 5
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages.It is a good idea to recycle the SQL Server Err...
Journey to SQL Authority with Pinal Dave, January 26, 2012
Views: 274 | Hits 3
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
Journey to SQL Authority with Pinal Dave, January 26, 2012
Views: 217 | Hits 1
Community is the most motivating force for me. I have often found situations where I have done more and better things because there was community around me. My latest book SQL Server Interview Questio...
Microsoft Certified Professional Magazine Online | Todays Top Picks, January 25, 2012
Views: 219 | Hits 9
Microsoft indicated today that SQL Server 2012 is nearing product release....
Journey to SQL Authority with Pinal Dave, January 25, 2012
Views: 237 | Hits 4
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
The Code Project Latest Articles, January 24, 2012
Views: 225 | Hits 17
Pl/Sql Procedure for Luhn, Check Digit validationSQL function to verify 'Check Digit' of given VISA/Master Card[^]Thanks--RA...
Journey to SQL Authority with Pinal Dave, January 24, 2012
Views: 233 | Hits 5
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
Julia Lerman Blog - Dont Be Iffy..., January 23, 2012
Views: 234 | Hits 33
A friendly reminder about the UserVoice site where you can suggest and vote on features youd like to see in Entity Framework (http://data.uservoice.com/forums/72025-ado-net-entity-framework-ef-feature...
Journey to SQL Authority with Pinal Dave, January 23, 2012
Views: 261 | Hits
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 22, 2012
Views: 304 | Hits 3
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.There is no replacement for this functionality. When the command is executed there is the message suggesti...
Journey to SQL Authority with Pinal Dave, January 22, 2012
Views: 229 | Hits 8
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 21, 2012
Views: 420 | Hits 29
Q. I need to modify Production Data directly on a Production database. What are some steps I can follow to ensure rollback is possible? Also, some steps to ensure I can capture mistakes before the dat...
Journey to SQL Authority with Pinal Dave, January 21, 2012
Views: 314 | Hits 8
Year 2011 was a year of learning and opportunity for me. My recent book,SQL Server Interview Questions and Answers,has received suchoverwhelminglove and support from all of you. While writing the book...
SQL Server DBA, January 20, 2012
Views: 195 | Hits 6
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plan...
ScottGus Blog, January 20, 2012
Views: 268 | Hits 20
This is the second in a series of posts Im doing on Windows Azure which is Microsofts Cloud Computing Platform. In todays post Im going to cover how to sign-up and get started with Windows Azure usi...