From
sqlservercentral.com
Email Address
subscriptions@sqlservercentral.com
Sent On
Mon, Dec 9, 2019 12:27 PM
Email Preheader Text
 SQLServerCentral Newsletter for December 9, 2019 Problems displaying this newsletter? . Featured
HTML
Â
SQLServerCentral Newsletter for December 9, 2019 Problems displaying this newsletter? [View online](.
[SQL Server Central](
Featured Contents
- [Increase Query Speed with Covering Indexes](
- [Implementing SQL Server Integration Services with Azure Data Factory](
- [From the SQL Server Central Blogs - When a SQL UPDATE Statement DELETES Rows](
- [From the SQL Server Central Blogs - Building an Azure Sandbox – Part 1 – The Basics](
Question of the Day
- [Rebuild vs Reorganize](
[Redgate SQL Source Control](
The Voice of the DBA
Â
Data for Defense
It's a dangerous world out there. Many of us hear about data breaches on a regular basis, and we often blame poor security at various organizations. Certainly there are a lot of silly mistakes made, whether in configuration or the mishandling of data in insecure environments. Security is a tough business, however, and most organizations don't have the budget to combat all the threats they face, at least not as effectively as a larger organization could.
I have more sympathy for organizations after reading about the work of some Microsoft security teams that [go up against the world's best hackers on a daily basis](. To truly understand the vulnerabilities in software, someone must also understand how to attack it. Those of us that only have a defensive mindset are inherently limited in how we design protective measures.
There is a group, the Microsoft Threat Intelligence Center (MSTIC), that looks for and tracks hackers around the world, trying to understand how they attack organizations. This is a group of multiple teams looking at nation state attacks, as well as complex software tricks, using the tremendous amount of data they gather from telemetry to analyze the different techniques and vectors used to exploit holes in our systems. They notify customers, letting them know when a customer need to be prepared to defend themselves.
This is a fascinating read, and one that makes me think that most of our organizations are going to be at cyberwar for the foreseeable future. Already we know that any system on the Internet is likely to be probed and attacked if it has vulnerabilities. Most of us are careful about what we expose, but we also know the weakest link in our organization could cause us issues.
We do the best we can, but often we do depend on other organizations, like Microsoft, to actively be identifying and helping us understand what to patch or change to protect ourselves. I assume Google and Apple have similar groups, notifying their customers of potential threats. These large vendors are likely the best positioned to help, given all the data they collect about their platforms. Certainly I worry about data privacy with these vendors, but I do think that their massive troves of data on how their software works can also benefit all of us.
Steve Jones - SSC Editor
[Join the debate, and respond to today's editorial on the forums](
[Redgate Database Devops](
Â
 Featured Contents
[Increase Query Speed with Covering Indexes](
steve@thesqlguy.com from SQLServerCentral
Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.
[Implementing SQL Server Integration Services with Azure Data Factory](
Additional Articles from Database Journal
Read on to step through the process of implementing Azure Data Factories.
From the SQL Server Central Blogs - [When a SQL UPDATE Statement DELETES Rows](
Bert Wagner from Bert Wagner
Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...
From the SQL Server Central Blogs - [Building an Azure Sandbox – Part 1 – The Basics](
Bradley Schacht from Bradley Schacht
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
Â
 Question of the Day
Today's question (by sergey.gigoyan):
Â
Rebuild vs Reorganize
Which statements are correct about the rebuilding and reorganizing indexes in MS SQL Server?
Think you know the answer? [Click here]( and find out if you are right.
Â
Â
 Yesterday's Question of the Day (by Steve Jones - SSC Editor)
The Schema Name
I gave this code to a junior DBA to create a new user:
CREATE USER SSISProcess WITH DEFAULT_SCHEMA = etl
We have some objects in the [etl] schema, but some of our code doesn't seem to create new objects in this schema correctly. We want to verify that the user can correctly see the schema. Someone logs in as the user, SSISProcess, and they want to check the default schema. What should they run to get this?
Â
Answer: SCHEMA_NAME()
Explanation: The schema_name() function will return your default schema if no parameter is provided. Ref: SCHEMA_NAME() -
[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 2017 - Administration
[SQL Server Reporting Services 2017 - Error 1503]( - Getting this error when SSRS (Express) service restarts: System.InvalidOperationException: Cannot start service SQLServerReportingServices on computer ' ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion   --- End of inner exception stack trace ---   at System.ServiceProcess.ServiceController.Start(String[] args)   at System.ServiceProcess.ServiceController.Start()   at ReportServicesConfigUI.Panels.ConfigurationPanelWithErrors.StartOrStopServiceTask(Boolean start, String serviceName) […]
[Weird network issue]( - Hi, I have an ssis package, that when I run it from the virtual server (the package is deployed on the catalog) and I use a job to run the package it takes 18 hours. I have set up another server (very small one called TEMP), is also a virtual server and deployed the same […]
SQL Server 2017 - Development
[Importing JSON]( - I am attempting to import JSON into my db and I'm getting stuck on a few nested objects. In this particular JSON fields are omitted when there isn't a value for that particular record, and that includes the nested objects. However, in some cases there is more than one nested object and I only want […]
[Parse character string into multiple fields]( - I need to parse a VARCHAR(255) field into four fields, three VARCHAR(5) and one VARCHAR(255). The VARCHAR field to be parsed is a variable length for example: 122 667|6 71|77|120 71|77|219|427|122|670|120|10 The characters before the first | go into field 1 The characters after the first | but before the second | go into field […]
SQL Server 2016 - Administration
[Database file size question]( - Hi all, I am working with a database from a third-party vendor that seems a bit odd to me. I just wanted to get your opinion so that I know I'm not going crazy. Just some facts about the database: SQL Server 2016 compatibility level Total size of the entire database is about 100 gigs […]
SQL Server 2016 - Development and T-SQL
[Find rows older than 60 days with Epoch time format]( - Hi, I'm trying to purge this table for any rows older than 60 days but the LogTime column is in Epoch format. I've read articles on how to convert it to human readable format and i just can't get it to work. Here is the table data. LogLevel LogTime INFO 1574434804509 INFO 1574434804509 INFO 1574434804509 […]
Administration - SQL Server 2014
[Slow deletes]( - Hi All, I have table with 1574963 rows and grown up to 1.21 Tera Bytes. Table has a clustered idx and additional nonclustered idx is created. App team is trying delete/archive some data in small chunks. CREATE TABLE [dbo].[LogData]( [c1] [bigint] NOT NULL, [c2] [int] NOT NULL, [c3] [int] NOT NULL, [c4] [ntext] NOT NULL, […]
Development - SQL Server 2014
[Syntax error using openquery()]( - Not quite sure what SQL is complaining about here so need some fresh eyes please. I'm trying to put the result of an openquery() into a variable. My code is: declare @ram_id varchar(50), @tsql nvarchar(1000) set @tsql = 'select @id = service_ref from OPENQUERY([remoteserver],"select Service_Ref from [remoteDB].[dbo].[Service_Request] where service_request_number = ''2''")' exec sp_executesql @tsql, N'@id […]
[Using stored procedures/dynamic sql to add columns]( - I am trying to use stored procedures to join columns to one table. I am joining more than 1 table to the original table but they have a common identifier. For example, right now I have Table 1 Id_number     month 82284         jan 82284  […]
[EXECUTE sp_executesql]( - Cordial Saludo. tengo el siguiente script DECLARE @SqlString NVARCHAR(500) DECLARE @ParmDefinition NVARCHAR(500) DECLARE @Valor_Tmp Numeric(12,2) SET @SqlString=LTRIM(RTRIM(@ValorFrm)) SET @ParmDefinition = N'@Valor_OUT Numeric(12,2) OUTPUT' EXECUTE sp_executesql @SqlString,@ParmDefinition,@Valor_OUT=@Valor_Tmp OUTPUT SET @Valor=@Valor_Tmp la variable @ValorFrm='SET @Valor_OUT=983,5-2(15.3)-1' Esta variable es una construccion similar a a+2(b)-1 construida por programa. El problema es que en el SSMS funciona y ejecuta bien […]
[A cursor with the name already exists]( - Hi, I have this code in a job that needs to run every 5 minutes. It works most of the time without issue. But 4-5 times a day I get the "a cursor with the name already exists" error. I added the LOCAL to the cursor declaration, but still get the error. I checked for […]
SQL 2012 - General
[Place data on another drive]( - Hi all! I have had to change from my good old dependable server to a local laptop. That gives some big challenges...  One of my databases is app. 2GB, and that just cannot be on a laptop harddisk - At least not mine. In comes my Synology drives, 2 X 8 TB  But […]
[How to understand the SQL Server Statistics information and Query Cost of Execut]( - In figure 1, there are SQL statements , these 2 sql statments join 2 tables, one is on current database server, the other is on another database server. the first SQL statement runs by SQL Server linker server to join; the second SQL statement uses openquery and linked server to get same data. and in […]
[Find how many week day crossed in a given date]( - Team I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month For Ex If I give 04th Dec 2019 as input > It should say, It is Tuesday and this date is first tuesday If the Input is […]
SQL Server 15 - Administration
[Bug in SQL 2019 - Error writing Log Shipping job history]( - Has anyone come across this bug, and if so have they found a fix for it? From what we can see the error is in a stored proc that seems to be in the Resource Database, and we don't have visibility on it. While Log Shipping still works, we have found without the Log History […]
Â
Â
[RSS Feed]([Twitter](
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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com
Â
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
EDM Keywords (173)
youtube
write
would
worry
world
works
working
work
well
week
wanted
want
vulnerabilities
voice
visit
visibility
verify
vendors
variable
value
user
use
us
understand
tuesday
trying
today
time
threats
thought
think
things
telemetry
talk
table
systems
system
sympathy
step
statements
start
sql
simple
signed
set
service
sent
seems
seem
see
scenario
say
run
return
result
respond
removed
rebuilding
reading
question
queries
put
purge
protect
process
probed
prepared
post
performance
patch
parsed
parse
parameter
package
output
organizations
opinion
openquery
one
omitted
often
objects
newsletter
needs
need
mishandling
mine
many
makes
lot
looks
local
likely
least
know
joining
join
job
internet
input
includes
improve
identifying
help
grown
group
going
go
gives
give
get
gave
gather
found
forums
fix
first
find
facts
face
expose
execut
ex
error
episode
email
effectively
editorial
developers
deployed
depend
defense
defend
debate
dbas
db
day
date
databases
database
data
cyberwar
customers
cursor
create
correct
convert
configuration
complaining
comes
combat
collect
code
checked
check
characters
change
catalog
cases
careful
cannot
bug
budget
best
attempting
attacked
attack
article
apple
answer
analyze
also
added
actively