Newsletter Subject
Storing a variable with a SELECT, and why it didn't work. (SQLServerCentral 4/2/2018)
From
sqlservercentral.com
Email Address
subscriptions@sqlservercentral.com
Sent On
Mon, Apr 2, 2018 04:37 AM
Email Preheader Text
A community of more than 1,600,000 database professionals and growing Featured Contents - - - - - Fe
HTML
[SQLServerCentral - www.sqlservercentral.com](
A community of more than 1,600,000 database professionals and growing
Featured Contents
- [Storing a variable with a SELECT, and why it didn't work.](
- [How to Back Up SQL Server to Azure Blob Storage](
- [Beyond Formatting: Improving SQL Code using SQL Prompt Actions](
- [Power BI Data Security â Sharing in Email]( (From the SQLServerCentral Blogs)
- [AT TIME ZONE: The easy way to deal with time zones and daylight savings time]( (From the SQLServerCentral Blogs)
Featured Script
- [New DMF sys.dm_db_log_stats in SQL Server 2017](
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 OR AND
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_mb float Total 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 {EMAIL}. 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
EDM Keywords (174)
years
write
work
well
ways
way
wanted
want
voice
visit
virtually
variables
variable
vacation
using
useful
used
use
twitter
trying
transmission
today
time
thorough
team
talking
talk
taken
sun
submit
storing
stop
steve
statements
sqlhelp
sqlfamily
sql
source
someone
solve
slacked
sitting
signed
share
sent
select
seize
see
score
says
say
sabbaticals
right
response
respond
removing
removed
remove
register
received
receive
realize
reading
quickbooks
question
put
project
proactive
presented
presentations
presentation
planning
people
peers
peer
pay
part
paraphrased
others
often
nothing
notes
none
newsletter
need
much
might
love
like
learned
learn
last
kpis
knowledge
knowing
know
interested
insights
information
improve
imposed
ideas
hours
hide
helped
help
happening
gui
gotchas
goaded
gives
give
get
free
found
forward
forums
formatted
following
find
figure
extract
ever
equal
end
enabled
email
effort
editorial
easy
dropped
driven
discussed
discuss
disabled
dice
desire
designed
debate
deal
day
date
data
credit
creating
created
create
couple
could
connected
condition
cond2
cond1
community
communicate
colleagues
colleague
cloud
category
calculating
buzz
branching
blogging
bloggers
blog
back
audience
ask
apply
anyone
answer
afterward
admit
added
actions