Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tag
Blogs
<< Newer
Items 21 to 40 of 27757
Older >>
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC ) Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
Read more...
By
Solomon Rutzky
2019/02/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,558 reads
Index maintenance freebies
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
Read more...
By
Arthur Daniels
2019/02/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,151 reads
7 more ways to Query Always on Availability groups
Post Updated: Replaced Query 3 with transactions/sec query. When we first published 7 ways to Query Always On Availability Groups using...
Read more...
By
david.fowler 42596
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
110 reads
SQLTreeo Add-In guide
SQLTreeo Add-In Plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide...
Read more...
By
Jakub Dvorak
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
107 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
Read more...
By
James Serra
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
535 reads
Do You Have a SQL Server Estate?
At Redgate, we do a lot of research. Maybe not as much as Microsoft Research, but we are always trying...
Read more...
By
Steve Jones
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
190 reads
Interview with Uwe Ricken
I have just done my first interview! The very special guest was Uwe Ricken! My idea for the interview was...
Read more...
By
damian.widera
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
81 reads
How to Encrypt and Restore Your SQL Server Database Backups
We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...
Read more...
By
Gavin Draper
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,215 reads
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of...
Read more...
By
Jason Brimhall
2019/02/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,184 reads
Speaking at SQLBits in March 2019
I’m super excited about the fact I’ll be speaking at SQLBits this year. It’s my first time as a speaker...
Read more...
By
KamilN78
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
85 reads
Upcoming SQLpassion Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
Read more...
By
Klaus Aschenbrenner
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
88 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
Read more...
By
Grant Fritchey
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
227 reads
Don’t Leave the Database Behind…Or Win If You Do
If you’ve had struggles with database development and had a real world disaster, you could win in a new Redgate...
Read more...
By
Steve Jones
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
127 reads
Error in SSMS: Attempted to read or write protected memory.
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...
Read more...
By
Kenneth Fisher
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
66 reads
Partitioning 5: The extra partition
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
Read more...
By
Arthur Daniels
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
85 reads
SQLSaturday Atlanta & South Florida 2019
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation....
Read more...
By
Andy Warren
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
106 reads
Four ways good database management can boost your business
Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your...
Read more...
By
Jakub Dvorak
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
114 reads
SQL Server, What Waits Happened In The Last X Seconds
There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...
Read more...
By
Gavin Draper
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
106 reads
Weekly reading #3
New week, new challenges! Great to see you again. We are always here Monday morning! No need to check earlier...
Read more...
By
damian.widera
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
79 reads
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub
(2019-Feb-18) With Azure Data Factory (ADF) continuous integration, you help your team to collaborate and develop data transformation solutions within the same data...
Read more...
By
Rayis Imayev
2019/02/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
309 reads
<< Newer
Items 21 to 40 of 27757
Older >>
Tags
career
(61)
security
(53)
t-sql
(49)
integration services (ssis)
(38)
powershell
(35)
backup and restore
(29)
reporting services (ssrs)
(29)
sql server
(28)
performance tuning
(23)
hardware
(19)
administration
(18)
analysis services (ssas)
(18)
networking
(18)
events
(14)
professional development
(13)
pass
(12)
sql server 2008
(12)
disaster recovery (dr)
(10)
sql server 2005
(10)
sqlsaturday
(10)
training
(10)
encryption
(9)
patrick leblanc
(9)
azure
(8)
data mining
(8)
database mirroring
(8)
indexing
(8)
performance
(8)
high availability (ha)
(7)
pass summit
(7)
replication
(7)
tools
(7)
xml
(7)
auditing
(6)
book reviews
(6)
database security
(6)
humor
(6)
interviews
(6)
leadership
(6)
sql saturday
(6)
always on
(5)
execution plans
(5)
learning
(5)
mdx
(5)
presenting
(5)
speaking
(5)
sql in the city
(5)
sql server 2012
(5)
sqlservercentral
(5)
statistics (data)
(5)
storage
(5)
virtualization
(5)
agent jobs
(4)
conferences/user groups
(4)
database design
(4)
databases
(4)
excel
(4)
fundamentals
(4)
maintenance plans
(4)
management studio (ssms)
(4)
master data services (mds)
(4)
professional organization for sql server
(4)
sql agent
(4)
transparent data encryption (tde)
(4)
windows 7
(4)
architecture
(3)
articles
(3)
cpu-z
(3)
cross apply
(3)
dmv queries
(3)
filestream
(3)
filetable
(3)
full text search
(3)
io
(3)
linkedin
(3)
live meeting
(3)
log shipping
(3)
microsoft
(3)
microsoft sql server
(3)
midlands pass
(3)
off-topic
(3)
oracle
(3)
permissions
(3)
script component
(3)
sql server 2000
(3)
sql university
(3)
string manipulation
(3)
transaction log
(3)
t-sql tuesday
(3)
windows security
(3)
business intelligence
(2)
cte
(2)
data warehousing
(2)
date manipulation
(2)
dbcc
(2)
deadlocks
(2)
etl (extract, transform, and load)
(2)
filegroups
(2)
hard disk
(2)
host bus adapter
(2)
hyper-v
(2)
job trends
(2)
logins
(2)
misc
(2)
monitoring
(2)
paritioning
(2)
policy based management (pbm)
(2)
power query
(2)
power view
(2)
powerpivot
(2)
redgate software
(2)
sas
(2)
sata
(2)
scripting
(2)
service broker
(2)
social networking
(2)
sql lunch
(2)
sql server 2008 r2
(2)
sql server 2014
(2)
sql server architecture
(2)
sqlbits
(2)
storage internals
(2)
stored procedures
(2)
time management
(2)
tips & tricks
(2)
trace
(2)
trust
(2)
twitter
(2)
.net
(1)
64-bit
(1)
ado variables
(1)
adobe flash
(1)
agile
(1)
ata
(1)
automation
(1)
availability
(1)
availability group (ag)
(1)
azure sql database
(1)
backups
(1)
bug
(1)
case
(1)
certificates
(1)
certifications
(1)
charindex
(1)
charity
(1)
checkpoints
(1)
clustering
(1)
coalesce()
(1)
code
(1)
columnstore index
(1)
compression
(1)
computers
(1)
configuration settings
(1)
constraints
(1)
contained databases
(1)
continuous integration (ci)
(1)
corruption
(1)
crystal clear
(1)
crystaldiskmark
(1)
ctp1
(1)
dac
(1)
data
(1)
data compression
(1)
data modeling
(1)
data protection european union
(1)
data warehouse
(1)
database diagram
(1)
database mail
(1)
database principals
(1)
database users
(1)
dba
(1)
dbcc checkdb
(1)
ddl trigger
(1)
deadlock graph
(1)
denali
(1)
deployment process
(1)
development
(1)
dimension
(1)
disk controller
(1)
distinct
(1)
dmv
(1)
dqs
(1)
dta
(1)
dts
(1)
dynamic sql
(1)
employees
(1)
error handling
(1)
error log
(1)
exceptional dba
(1)
exceptional dba awards
(1)
exchange
(1)
extended events (xe)
(1)
extended support
(1)
files and filegroups
(1)
for each task
(1)
formatting
(1)
freeproccache
(1)
geekbench
(1)
geoflow
(1)
goals
(1)
grant
(1)
graphs
(1)
grouping sets
(1)
hashing
(1)
hekaton
(1)
highavailability
(1)
hp data protector
(1)
i/o
(1)
i/o statistics
(1)
ide
(1)
iif
(1)
inner join
(1)
integrity
(1)
isnull
(1)
isnumeric()
(1)
job quality
(1)
joins
(1)
json
(1)
licensing
(1)
linear gauge control
(1)
log
(1)
mainsteam support
(1)
maintenance
(1)
maintenance and management
(1)
management
(1)
mcts
(1)
memory
(1)
merge
(1)
migration
(1)
miscellaneous
(1)
msde
(1)
mvp
(1)
netbook
(1)
netbooks
(1)
nolock
(1)
normalization
(1)
null
(1)
ole-db connection
(1)
orphaned users
(1)
output clause
(1)
over clause
(1)
page life expectancy
(1)
page splits
(1)
parallelism
(1)
partitioning
(1)
passwords
(1)
performancepoint
(1)
pivot
(1)
precedence constraints
(1)
presenting live meeting
(1)
procedure cache
(1)
productivity
(1)
query
(1)
query optimization
(1)
query performance
(1)
quick tip
(1)
raid
(1)
readonlyvarables
(1)
readwritevariables
(1)
readyboost
(1)
recursion
(1)
report builder
(1)
resource database
(1)
resource waits
(1)
restore
(1)
review
(1)
roles
(1)
salaries
(1)
schemas
(1)
script transformation editor
(1)
scripts
(1)
scrum
(1)
scsi
(1)
server principals
(1)
sharepoint 2013
(1)
shrink database
(1)
signal waits
(1)
smo
(1)
sp_server_diagnostics
(1)
sparse columns
(1)
sql compare
(1)
sql connections
(1)
sql injection
(1)
sql prompt
(1)
sql server 2011
(1)
sqlclr
(1)
sqlcmd
(1)
sqldenali
(1)
sqldumper
(1)
sqlio
(1)
ssd
(1)
sspi
(1)
stack
(1)
star join
(1)
storage management
(1)
strings
(1)
striped backups
(1)
subquery
(1)
surface
(1)
surface area configuration tool
(1)
symmetric keys
(1)
syscolumns
(1)
table valued function (tvf)
(1)
table valued parameters (tvp)
(1)
tally table
(1)
ted kummert
(1)
test data
(1)
tim mitchell
(1)
tips
(1)
transactions
(1)
triggers
(1)
troubleshooting
(1)
try..catch
(1)
try_convert()
(1)
udf
(1)
undocumented stored procedures
(1)
user defined function (udf)
(1)
user defined functions
(1)
user groups
(1)
users
(1)
validate email
(1)
validate ssn
(1)
validate url
(1)
validation functions
(1)
variables
(1)
views
(1)
visualizations
(1)
voice of the dba
(1)
waits and queues
(1)
window functions
(1)
windows
(1)
windows event log
(1)
work
(1)
writing
(1)
x64
(1)
xquery
(1)
Copyright © 2002-2019 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.