SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Paying It Forward

Today we have a guest editorial as Steve is on vacation. This editorial was originally published on July 9, 2014 .

I was struck recently by two contradictory points of view. One of my SQL Server heroes, Paul Randal, tweeted "Pay it forward folks, never forget to pay it forward when you get help. Everyone starts with zero #sqlserver knowledge." That same day, I was talking with another DBA about if he might be interested in creating a presentation for an upcoming SQL Saturday, and his response was (paraphrased) "Why do I want to put the effort into that just to have someone steal my ideas from the slides?"

Ouch.

When I started blogging three and a half years ago, I just wanted to see if I could do it.  I have always enjoyed writing, but after years of reading other useful (and sometimes humorous) SQL Server blogs, I just wanted to see if I could do it myself.  I have learned - and still learn - so much from the wide variety of bloggers in the #sqlfamily.

I have taken a few "sabbaticals" from blogging over the last few years (AKA, I slacked off), but I have always come back, and it is often because of someone commenting on my blog or on Twitter.  Someone will say I helped them solve a particular problem, while others just say “thanks.”  It always feels good when my blog saves my peers some work because they can use my notes to get a head start on their own situations.

Presenting follows a very similar path to blogging.  The first time I presented, I was goaded into it by a peer, and when I said "yes," I just wanted to see if I could do it.  I have learned so much more over the years from conference sessions, SQL Saturdays, and virtual webcasts than I ever have by sitting in a 5-day Microsoft curriculum class.  

Most of my presentations to date have been about maintenance (backups, indexing, etc.), but I am branching out as I see the desire from others for different things.  Again, creating a presentation has the double bonus - I have to learn new things and be thorough to create a presentation and then I get to share that knowledge with a room full of people and help them. I have to admit that a little part of me is driven by the buzz of knowing I have connected with someone - when an attendee comes up to me afterward and says "you know, now I get it!"

I work with many people in other database platforms, operating systems, etc. and none of them have anything like the #sqlfamily, where high level consultants will help you, often for free, just because you ask for #sqlhelp on Twitter or because you stay behind after a SQL Saturday session to talk.

To me, it is simply amazing - if you have ever felt this way, then you too can pay it forward.

Andy Galbraith from SQLServerCentral.com

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

ADVERTISEMENT
SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

SQL Prompt

Write, format, analyze, and refactor SQL fast with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial

Featured Contents

 

Storing a variable with a SELECT, and why it didn't work.

Kenneth Fisher from SQLServerCentral.com

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well. More »


 

How to Back Up SQL Server to Azure Blob Storage

Additional Articles from Brent Ozar Unlimited Blog

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds. More »


 

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

This article shows how to use the SQL Prompt actions that you can apply as part of the Format SQL command. These actions are designed to help improve the overall quality of your SQL code, in various subtle but meaningful ways, such as qualifying object names, standardizing the use of aliases, adding semicolons to the end of statements, and removing unnecessary square brackets around object names. More »


 

From the SQLServerCentral Blogs - Power BI Data Security – Sharing in Email

DataOnWheels from SQLServerCentral Blogs

  Microsoft has expanded sharing by allowing users to share Power BI content via email. In a previous post, I discussed... More »


 

From the SQLServerCentral Blogs - AT TIME ZONE: The easy way to deal with time zones and daylight savings time

Bert Wagner from SQLServerCentral Blogs

Many people think daylight savings time was created to help align the hours that the sun is up with our... More »

Question of the Day

Today's Question (by Evgeny Garaev):

What is equal to the following WHERE condition?

WHERE <cond1> OR <cond2> AND <cond3>

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 2 points in this category: T-SQL.

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

ADVERTISEMENT

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I realize that the guest user is enabled in the Finance database, and I want to remove this as an attack vector. How can I prevent anyone from using the guest account in the Finance database?

Answer: Run this in the Finance database: REVOKE CONNECT FROM guest

Explanation:

The guest user cannot be added or dropped, but can be disabled by removing the connect permission.

Ref: Guest user account in SQL Server - click here


» Discuss this question and answer on the forums

Featured Script

New DMF sys.dm_db_log_stats in SQL Server 2017

Jayendra Viswanathan from SQLServerCentral.com

I would like to share few of the attributes available for sys.dm_db_log_stats. This was the extract from my SQL Server machine. Since sys.dm_db_log_stats return table, I use CROSS APPLY to extract the matched data. Below are the few columns showed as examples. sys.dm_db_log_stats  can be used to display lots of data useful for SQL DBA's and SQL Developers.

Output for First Set : 

Name is the database name.

total_vlf_count  is the Total number of virtual log files (VLFs) in the transaction log.

log_truncation_holdup_reason is NOTHING in my example.

log_backup_time is the last BACKUP time from the SQL Server.

active_vlf_count is the total active VLF counts.

active_log_size_mbfloatTotal active transaction log size in MB.

Output for Second Set : 

Name is the database name 
s.recovery_model is the database recovery model , 1 is for FULL , 3 is for SIMPLE.
collation_name is SQL_Latin1_General_CP1_CI_AS
user_access_desc is MULTI_USER
recovery_model_desc 

More »

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 2017 : SQL Server 2017 - Development

Temporal Tables - Delete Conflict - Well, I'm trying to figure out a way around another massive hole in a SQL Server feature.  I have temporal...


Reporting Services : Reporting Services

How to hide the time in the date parameter of ssrs report? - I'm calculating the last day of the previous month in the "Report End Date" parameter of my report. Following is the...


Data Warehousing : Integration Services

Depoly BIDS package to remote server - Hi all, I have the following set up (imposed by our IT team, not by choice). Locally (where i write the...


SQL Server 7,2000 : General

QuickBooks to SQL Server - Does anyone have any ideas of ways to communicate between SQL Server and Quickbooks?  I have found a couple of...

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.
This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com