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 25963
Older >>
SQL query to shrink all log files on sql instance
USE master exec sp_MSforeachdb ' use [?] print ''?'' print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200)) if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE '' dbcc shrinkfile(2,1) '
Read more...
By
SQLPals
2018/04/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
79 reads
T-SQL Developer Interview Questions with Answers
What SQL command do you use to pull and filter data from a table ? SELECT [Column List] FROM [Table Name]...
Read more...
By
SQLPals
2018/04/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
82 reads
GUID or Integer Primary Key? If you are designing a new data model or maybe you are looking to improve an...
Read more...
By
SQLPals
2018/04/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
GDPR, Database Backups, and the Right to be Forgotten
I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...
Read more...
By
Grant Fritchey
2018/04/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,441 reads
Remove-DbaBackup with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
Read more...
By
Steve Jones
2018/04/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,996 reads
SQL server database size, location and volume info
For one of my clients, I needed to know and document not only database names, size and locations but also...
Read more...
By
SQLPals
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
60 reads
Generate SQL script to extract user permissions from a SQL database
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
Read more...
By
SQLPals
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
62 reads
How to check whether and when sql index statistics were updated last time?
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
Read more...
By
SQLPals
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
56 reads
How to start SQL Server job using TSQL and wait for it to complete?
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
Read more...
By
SQLPals
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
53 reads
The Prompt Actions Menu
A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that...
Read more...
By
Steve Jones
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
250 reads
Overview of SQL Server Backup Types
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
Read more...
By
Prashanth Jayaram
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
149 reads
Azure SQL Database and Columnstore Indexes
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
Read more...
By
Arun Sirpal
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,762 reads
Change SQL Server Collation – Back to Basics
One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment...
Read more...
By
Jason Brimhall
2018/04/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,819 reads
Dates and Times in SQL Server: the science of time redux
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
Read more...
By
Randolph West
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
162 reads
SSMS: Batch Separator (Day 35)
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
Read more...
By
Wayne Sheffield
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
139 reads
Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications,...
Read more...
By
araujo.christian
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
120 reads
An Open Letter to PASS and John Q Martin
Dear Mr. Martin and the PASS Organization, In the spirit of advocating for change in a public way, I’m writing this...
Read more...
By
Steve Jones
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
312 reads
Exploring system tables, views, SPs etc
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have...
Read more...
By
Kenneth Fisher
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
425 reads
Free Training 24HOP
In my sessions, I always talk about how to build your skill set when you don’t have a budget for...
Read more...
By
SQLEspresso
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
153 reads
Checking Availability Groups with dbachecks
It’s been 45 days since we released dbachecks Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9 — Rob Sewell (@sqldbawithbeard) February...
Read more...
By
Rob Sewell
2018/04/18
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,544 reads
<< Newer
Items 21 to 40 of 25963
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
(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 triggers
(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-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.