External Article

The 2015/2016 Simple-Talk Awards

  • Article

Once more Simple-Talk invites its readers to vote on the top nominations for the Simple-Talk Awards. Find out who or what has been nominated for each of this year's nine categories, and cast your vote to decide the winners - voting closes tomorrow!


2,523 reads

SQLServerCentral Article

The 2014 Tribal Awards - Nominations Open

  • Article

Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.

2014-12-09 (first published: )

703 reads

Technical Article

RE: Data centre failure

  • Reply

Two although years ago.One had redundant communication lines external, both running under the same sidewalk.  Contractor had to dig up the sidewalk and cut both cables.Downtime, just over 24 hours.Earlier was water running into the power panel,  (They were drilling for cooling tower lines on the parking garage above) and blew up the whole incoming power […]


Technical Article

RE: enterprise manager

  • Reply

Start | Run | mmc Console | Open | C:\Program Files\Microsoft SQL Server\80\Tools\Binn Select 'SQL Server Enterprise Manager.MSC' That should do the trick. Or, you could make a shortcut to C:\WINNT\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"


Technical Article

RE: casting a varchar as datetime

  • Reply

If you look up CAST AND CONVERT in BOL they have a list of the possible date formats. The date format that you run defines the order of the entries when converting. I tried using set dateformat to do a direct CAST however it did not work (don't know why).



Daily Coping 26 Jan 2023


Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell


Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project


SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs


SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Backup Log Init run again by mistake manually.

By vpmaciel

backup log to int run every hour. If a log init backup is run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers