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 - Questions
My laptop accidentally tripped on the stairs and this was out. When I turned on the laptop normally and wanted to connect to a database sql server 2008, ...
by mizquierdo
22:09 25-Jul-2014
SQLServerCentral - Questions
Problem with Formatting please find attachment Basically i have three Tables Request ID Parent ID Account Name Addresss 1452 1254789 ...
by chethanmalur
19:15 25-Jul-2014
SQLServerCentral - Blogs
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture ...
16:29 25-Jul-2014
SQLServerCentral - Blogs
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks. Securing the ETL Pipeline We’re ...
15:36 25-Jul-2014
SQLServerCentral - Blogs
Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need ...
15:00 25-Jul-2014
DatabaseWeekly - Newsletter
Even if you aren't running SQL Server, but want to understand best how to build high performance Azure IaaS applications, this article has a wealth of ...
14:47 25-Jul-2014
DatabaseWeekly - Newsletter
Raw numbers are easy to report and analyze, but without the proper context, they can be misleading. Is the effect you're seeing real, or a simple result ...
14:47 25-Jul-2014
SQLServerCentral - Questions
Hello: Although recall seeing the following option in SQL 2005 in the past, but unable to see it on an installation now. Any idea where this is hidden? ...
by Mansour Shoari
14:40 25-Jul-2014
SQLServerCentral - Questions
In C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log there are log files created not everyday but may be two or 3 per day. I am ...
by chitrarekha.saha
14:15 25-Jul-2014
SQLServerCentral - Questions
Hi, We are Currently using SQL Server 2008. We have SQL Server 2000 (80) Compatibility----6 Databases We have SQL Server 2005 (90) Compatibility----5 ...
by sqlqa
13:54 25-Jul-2014
DatabaseWeekly - Newsletter
In a series of articles will look at how to use Node.js with some of the most popular products and platforms like SQL Server, MongoDB, Microsoft Azure, ...
13:47 25-Jul-2014
DatabaseWeekly - Newsletter
The 2014 HIMSS Analytics Cloud Survey documents the use and concerns of healthcare organizations use ...
13:47 25-Jul-2014
DatabaseWeekly - Newsletter
Backup should never be treated as a "one-size fits all" thing. Your backup and recovery mechanisms need to be matched to your particular technological ...
13:47 25-Jul-2014
SQLServerCentral - Blogs
One of the many things we're discussing going into the 2014 PASS election is what the planned two official campaign events should be. I asked on Twitter ...
13:03 25-Jul-2014
DatabaseWeekly - Newsletter
ASP.NET Web API OData allows you to take advantage of your existing knowledge of both APS.NET MVC and the ASP.NET Web API to easily create OData endpoints. ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
DevOps is a good term and a good idea for software development. If a company implements it well, then it works and people are happier with the way software ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
Paged designs, floating figures, and multi-column layout are widely used on mobile devices today. These are all native apps. If we want the web to win ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
Google uses about 200 ranking factors in their page-ranking algorithm. I've put together a complete list. Some are proven, some are controversial and ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
The department is "working urgently to correct the problem and expect our system to be fully operational soon. "We do not believe there was any malicious ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
Traditionally, a product strategy is the result of months of market research and business analysis work. It is intended to be factual, reliable, and ready ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
UnQL (Unstructured Query Language), the project to provide a universal access language to the NoSQL domain got a lot of initial attention but didn't gain ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check?
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
We have Amicus shirts with "Make Mistakes" emblazoned across the front. They're meant to encourage people to take risks, be bold, and embrace small failures ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
In fact I know of 3 possible reasons (and there may be more I don't know) for seeing a primary key error. Technically they occur for any unique key, of ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
It's always a good idea to start with the question, "Do I trust my data?"- no matter what stage of the data management cycle you are in. Information management ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
All too often Scrum teams cut corners or abuse the Scrum framework - they do the easy parts of Agile without doing the hard parts. These teams may see ...
12:47 25-Jul-2014
DatabaseWeekly - Newsletter
I was working on a small piece of code the other day that was calculating the seconds for an event. I had a function that returned me the seconds as an ...
11:47 25-Jul-2014
DatabaseWeekly - Newsletter
SQL Prompt can automatically create aliases for tables. However, as I've worked on different systems, I've often found that development teams like to ...
11:47 25-Jul-2014
DatabaseWeekly - Newsletter
How do you get the boss to pay for training? In my experience you have to ask, align and persist.
11:47 25-Jul-2014
SQLServerCentral - Questions
finding object dependencies.
by a_s
11:15 25-Jul-2014
SQLServerCentral - Blogs
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real ...
11:00 25-Jul-2014
SQLServerCentral - Blogs
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party entertainers, long suffering ...
10:24 25-Jul-2014
SQLServerCentral - Questions
Hi , Recently my transaction log in QA environment became full and caused an issue. When I looked in to that I found an issue with a stored procedure.The ...
by aRookieBIdev
09:35 25-Jul-2014
SQLServerCentral - Questions
I am using the `[sys].[dm_db_index_usage_stats]` view to find unused indexes. I am looking for all of the following fields to be equal to `0`: [user_scans] ...
by gotqn
08:46 25-Jul-2014
SQLServerCentral - Questions
I have historic tables in my database created with dates attached to the name of the table. For example DatabaseName; [Honda] TableNames Chels_20140725 ...
by chelsonkennedy
08:23 25-Jul-2014
SQLServerCentral - Questions
i have two tables called t and t1 . Problem : if no data is available in #t1 then i need to insert and if data is avialable then i need to update . suppose ...
by FranklinSenthil
00:08 25-Jul-2014
SQLServerCentral - Editorials
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
23:00 24-Jul-2014
SQLServerCentral - Main Articles
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
23:00 24-Jul-2014
SQLServerCentral - Main Articles
Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey ...
23:00 24-Jul-2014