A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

Byte Me: File Lost

Join the debate, and respond to today's editorial on the forums

Could you help with some research?

The Foundry team at Redgate want to hear about your experience with audit and compliance. Fill in this short survey to help out, and also to enter their prize draw for a $100 Amazon gift card. Complete survey.

Not enough hours in your day?

The SQL Toolbelt lets you reduce the time spent on SQL Server development and administration. Cambridge University developer David Spaxman, for example, says: “I’m saving 10-12 hours a week using the SQL Toolbelt.” Learn how you can double your productivity, speed up deployments and protect your data. Download a free trial.

Featured Contents

Data Warehousing in the cloud – Azure Style

Chris Testa-O'Neil from SQLServerCentral.com

Learn about Azure SQL Data Warehouse and how to get started. More »

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More »

PowerShell Time Saver: Automatic Defaults

Additional Articles from SimpleTalk

Because PowerShell needs to be usable as an immediate scripting language by IT professionals who type in commands at a console, there have to be language devices such as aliases that can make for terseness when appropriate. There are several ways of cutting down the verbiage in a script, and being able to specify default values via $PSDefaultParameterValues is one of the more generally useful ones. Michael Sorens explains how it can save you time in your daily work. More »

From the SQLServerCentral Blogs - Taking dbatools Test-DbaLastBackup a little further

Rob Sewell from SQLServerCentral Blogs

In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup Today I thought I would... More »

From the SQLServerCentral Blogs - Creating a list of random numbers

Kenneth Fisher from SQLServerCentral Blogs

I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly... More »

Question of the Day

Today's Question (by Steve Jones):

I want to assign the numeric value of 42 to the variable, i, in the R language. How do I do this?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: R Language.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Expert Scripting and Automation for SQL Server DBAs

Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What is returned from this code, in a SQL Server 2016 installation with the US English defaults?

 DECLARE @t DATETIME2 = '10:00 am' SELECT @t

Answer: 1900-01-01 10:00:00.000

Explanation:

If you pass just a time value into the datetime datatype, this will use the default date of 1900-01-01 for the date part.

Ref: datetime2 - click here

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

Database Architecture Question - Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend... My organization...

SQL Server 2016 DBA Training - Hi people, I've been working as a SQL developer for a number of years, with an increasing amount of DBA work...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Session Context In SQL Jobs - I have setup a job to test if session context could be used across job steps. From what I can...

SQL Server 2014 : Administration - SQL Server 2014

Compilation lock and blocking - Hello, We are seeing compilation lock blocking on one of our production server. Initially we saw it was because of the...

SQL Server 2014 : Development - SQL Server 2014

SQL Server | Architecture design - - Hi Experts, I have couple of basic queries regarding the way SQL Server is designed/works: 1) Schemas in SS is bit different from...

SQL Server 2012 : SQL 2012 - General

Management Studio freezing after writing a few lines of code - Hi all I've got a bit of an odd scenario. We're using SSMS 2012 against an 2012 Business Intelligence SQL install. Sometimes (it...

Can you reorganize this SQL stmt please ? - This doe snot throw errors but it does not pass any rows ( I mean it just goes on forever ) Some...

Help me rearrange the SQL statement - It works but ? - Folks I got this off of a SSRS report. This works fine. However I can't seem to make sense from this. I...

Grant Execute Permission on sp_audit_write - I got "sp_audit_write" working but only with ids granted to SYSADMIN. Looking at Microsoft documents, the only permission required is...

Query on locks taken in a Deadlock - Hi All, I’m wondering why one of the processes (4025498) involved in a deadlock has taken an IX lock on object...

SQL Server 2012 : SQL Server 2012 - T-SQL

How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates...

SQL Server 2008 : SQL Server 2008 - General

redesigning table to accommodate new data types - i have a table in which there is column called Marks of type int. This is used to save the...

SQL Files open in a new SSMS instance - When I double click on a .sql file, it starts up SSMS and loads my file. When I click on...

HDD Space problem when running queries - Hi, all. We are running SQL Server 2008 on Windows Server 2008 (both 64 bit) and I am running into...

SQL Server 2008 : T-SQL (SS2K8)

Create From and To dates - Hi, I have the @rent table as below which holds the tenant rent charged values. The table has inconsistency as there...

Reporting Services : Reporting Services

SSRS How to trigger subscription when data is ready - hi guys, I have a few Reports that are subscripte bei a normal subscription meaning having a fixed time where it...

Programming : General

T-SQL Code Analysis Tools - I am researching T-SQL Code Analysis tools, like the equivalent of an FxCop for T-SQL that will scan thousands of...

bcp row terminator - I am trying to export the contents a query into a ASCII file. I need the character "LINE FEED" to be...

Data Warehousing : Strategies and Ideas

No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...

SQL Server 2005 : Administering

SQL Server DBA Certification - Hi All: I want to become a certified DBA, i'm not sure what path is the right one. I have exprience...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.