Here at Database Weekly, we scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week. Here, we have an assortment of the latest articles from selected sources.

At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.

Latest Articles


SQLServerCentral - Blogs
TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t) is hosting and wants us to talk about ...
11:00 14-Oct-2014
SQLServerCentral - Questions
Team, I want to get the report of SQL production server how it performed last one hour or any specific time range..Please suggest. Like..disk I/o,long ...
by fayaz
10:45 14-Oct-2014
SQLServerCentral - Blogs
Use SQL Server Checksum in Data Warehousing TwitterGoogle+The post SQL Server Checksum appeared first on Derek Wilson - Blog.
10:35 14-Oct-2014
SQLServerCentral - Questions
I have a correlated subquery scenario: Select id, measurecol,datecol from table1 t1 where datecol = (Select max(datecol) from table1 t2 where t1.id ...
by bhojarajan_vtj
10:01 14-Oct-2014
SQLServerCentral - Blogs
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The ...
08:45 14-Oct-2014
SQLServerCentral - Questions
Hi All, perhaps it is very simple question, but I could not find a solution for that. I would like to find all entries which consist a word "A" and ...
by czajna
08:31 14-Oct-2014
SQLServerCentral - Blogs
This month's T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show). Ada Lovelace has been an inspiration ...
05:56 14-Oct-2014
SQLServerCentral - Editorials
Steve Jones talks about making deliberate career choices, or just moving from place to place without any worry about the job. Do you care about what work ...
23:00 13-Oct-2014
SQLServerCentral - Main Articles
Point-in-Time Restore is a new feature of the SQL Azure Service Tiers
23:00 13-Oct-2014
SQLServerCentral - Main Articles
It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet ...
23:00 13-Oct-2014
SQLServerCentral - Main Articles
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using ...
23:00 13-Oct-2014
SQLServerCentral - Main Articles
Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding ...
23:00 13-Oct-2014
SQLServerCentral - Questions
Below is my attempt at creating a view. Currently, I'm getting an error close to the AS statement. ...
by BGorham
22:14 13-Oct-2014
SQLServerCentral - Questions
I have a name stored as Smith PA,John E in a table of Doctors. How would I parse the last name "Smith" and First Name "John" from this list? Not all ...
by siera_gld
20:26 13-Oct-2014
SQLServerCentral - Questions
I have a task regarding access database. I and my organization is using access database to maintain ...
by MarshallBurns
19:08 13-Oct-2014
SQLServerCentral - Blogs
This Wednesday we're having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past couple months we've referred ...
15:40 13-Oct-2014
SQLServerCentral - Questions
I have recently found that for `NVARCHAR(MAX), VARCHAR(MAX), VARBINARY(MAX)` data types you can use special [.WRITE][1] clause which is log minimally ...
by gotqn
14:41 13-Oct-2014
SQLServerCentral - Blogs
It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL). ...
14:00 13-Oct-2014
SQLServerCentral - Blogs
Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have time to review my presentation and then work ...
13:00 13-Oct-2014
SQLServerCentral - Blogs
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. ...
12:29 13-Oct-2014
SQLServerCentral - Blogs
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training ...
12:24 13-Oct-2014
SQLServerCentral - Blogs
I can't believe this will be the fourth SQL in the City in London next week. It's amazing to me that we've managed to build this great series of one day ...
12:12 13-Oct-2014
SQLServerCentral - Questions
Hello, we are using SQl Server 10.0.2531 version. i executed the database backup query for one database whose size is 1GB and it is running for the last ...
by sand143eep
08:28 13-Oct-2014
SQLServerCentral - Blogs
1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP ...
07:31 13-Oct-2014
SQLServerCentral - Editorials
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running ...
23:00 12-Oct-2014
SQLServerCentral - Main Articles
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
23:00 12-Oct-2014
SQLServerCentral - Main Articles
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
23:00 12-Oct-2014
SQLServerCentral - Main Articles
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference - planned by and for ...
23:00 12-Oct-2014
DatabaseWeekly - Newsletter
It seems lately there is an intentional disregard of the core principles of business development of software intensive systems. The #Noestimates community ...
16:50 12-Oct-2014
SQLServerCentral - Blogs
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the list of tech sites which I used to refer ...
14:43 12-Oct-2014
SQLServerCentral - Questions
So here is the doubt : e.g. There is a stored proc who takes one input parameter and I want to set ...
by SqlUser1
13:54 12-Oct-2014
SQLServerCentral - Blogs
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to think about. Am I presenting the ...
13:19 12-Oct-2014
SQLServerCentral - Questions
We recently have implemented separating TempDB Data Files using SSD (12 files and same sizes with trace flag 1117) and Log files using SAN LUN. DMV is ...
by mcljeff
04:17 12-Oct-2014
SQLServerCentral - Questions
Hi every body: I'm new in Sql server. I AM TRYING TO CONVERT A DATE IN DAY-MONTH- YEAR ' ( '+ Convert(Date, '2011/08/15','ddmmyyyy' )+' ) TOT ( '+ ...
by boris1610
23:31 11-Oct-2014
Simple-Talk - Blogs
It is Saturday afternoon in Orlando and as I type this, my wife, Karla,  is in St Louis attending SQL Saturday #333.   I have just finished my HoneyDo ...
19:14 11-Oct-2014
SQLServerCentral - Questions
I have a column in sql server table in which sever name is the data. I need to split the server name in to two columns. Host name goes in to one column ...
by bunty
15:27 11-Oct-2014
SQLServerCentral - Questions
How can i set the connection time out in sql 2005 for the incomimg queries from appliction servers.
by Bincy
05:31 11-Oct-2014
SQLServerCentral - Blogs
Originally posted on Peter's blog:If a user is a member of Sysadmin server role of SQL Server 2005, the user runs xp_cmd_shell in the security context ...
00:18 11-Oct-2014
SQLServerCentral - Blogs
Triggers are the database objects that are used in relational databases. These are executed or fired automatically, when DDL or DML command statement ...
21:29 10-Oct-2014