Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
Blogs
Items 1 to 20 of 13978
Next 20 >>
Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
Read more...
By
SteveHood79
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
122 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality. I wrote recently about Windows 8 and...
Read more...
By
Steve Jones
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
121 reads
Windows, RIP (1992 – 2013)
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
Read more...
By
Klaus Aschenbrenner
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
120 reads
Certifiable?
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
Read more...
By
Angela Henry
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
109 reads
SQLSaturday #220 Atlanta
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...
Read more...
By
Thomas LeBlanc
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
94 reads
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers
We came across a scenario where database bak files being created from long time which are no more in use...
Read more...
By
Prashanth Jayaram
2013/05/17
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
722 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
Read more...
By
SteveHood79
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
249 reads
SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?
This is my first SQLSaturday and I’m super excited to attend this event. SQLSaturday’s are always a great opportunity to learn something exciting,...
Read more...
By
AnupWarrier
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
94 reads
Virtualization Networking Tips for SQL Server 2012 AlwaysOn
A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...
Read more...
By
kleegeek
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
165 reads
Parameterizing an Excel Spreadsheet
I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...
Read more...
By
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
271 reads
When the person you hire is not the person you hire
This is something I just heard about recently, but then experienced it for myself. This story was told to me: A...
Read more...
By
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
162 reads
My 2013 SQL Saturday Schedule!
I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...
Read more...
By
Jen McCown
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
109 reads
Bill Gate’s speech
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
Read more...
By
Prashanth Jayaram
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
85 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...
Read more...
By
john_wong_ca
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
97 reads
Magnify SQL Text with SSMS 2012
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....
Read more...
By
Sqlchicken
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
101 reads
Rated R (A Teaser)
How many lines of TSQL codes and Window Functions you need to come up with this? With R, it takes about...
Read more...
By
MarlonRibunal
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
130 reads
Lost Phone, Ring,Glasses,Etc, At the Office
If you work at a company with more than a 100 or so employees you probably get an email every...
Read more...
By
Andy Warren
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
116 reads
From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
Read more...
By
Andy Warren
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
144 reads
DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions
sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx Returns information about transactions at the database level. Some time , T-log...
Read more...
By
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
109 reads
Dragging a name from the object explorer to a query window
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
Read more...
By
Kenneth Fisher
2013/05/16
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,819 reads
Items 1 to 20 of 13978
Next 20 >>
Tags
career
(53)
security
(46)
t-sql
(43)
integration services (ssis)
(36)
powershell
(32)
sql server
(28)
reporting services (ssrs)
(26)
performance tuning
(23)
administration
(17)
analysis services (ssas)
(17)
networking
(17)
backup / recovery
(16)
hardware
(16)
professional development
(13)
pass
(12)
sql server 2008
(12)
backup / restore
(11)
events
(11)
sql server 2005
(10)
sqlsaturday
(10)
training
(10)
disaster recovery (dr)
(9)
patrick leblanc
(9)
database mirroring
(8)
encryption
(8)
indexing
(8)
pass summit
(7)
replication
(7)
tools
(7)
auditing
(6)
book reviews
(6)
database security
(6)
leadership
(6)
xml
(6)
data mining
(5)
high availability
(5)
interviews
(5)
learning
(5)
presenting
(5)
speaking
(5)
sql in the city
(5)
sql saturday
(5)
sql server 2012
(5)
sqlservercentral
(5)
statistics
(5)
storage
(5)
alwayson
(4)
conferences/user groups
(4)
databases
(4)
fundamentals
(4)
humor
(4)
maintenance plans
(4)
management studio (ssms)
(4)
professional organization for sql server
(4)
virtualization
(4)
windows 7
(4)
architecture
(3)
articles
(3)
azure
(3)
cpu-z
(3)
dmv queries
(3)
filestream
(3)
filetable
(3)
full text search
(3)
io
(3)
jobs
(3)
linkedin
(3)
live meeting
(3)
log shipping
(3)
mdx
(3)
microsoft
(3)
microsoft sql server
(3)
midlands pass
(3)
off-topic
(3)
oracle
(3)
performance
(3)
script component
(3)
sql agent
(3)
sql server 2000
(3)
sql university
(3)
string manipulation
(3)
transaction logs
(3)
transparent data encryption (tde)
(3)
windows security
(3)
business intelligence
(2)
cross apply
(2)
data warehousing
(2)
database design
(2)
date manipulation
(2)
dbcc
(2)
deadlock
(2)
etl
(2)
excel
(2)
execution plans
(2)
filegroups
(2)
hard disk
(2)
host bus adapter
(2)
job trends
(2)
logins
(2)
master data services (mds)
(2)
permissions
(2)
policy based management (pbm)
(2)
power view
(2)
powerpivot
(2)
red gate software
(2)
sas
(2)
sata
(2)
scripting
(2)
service broker
(2)
social networking
(2)
sql bits
(2)
sql lunch
(2)
sql server 2008 r2
(2)
sql server architecture
(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)
availability
(1)
backups
(1)
bug
(1)
case
(1)
certificates
(1)
certifications
(1)
charindex
(1)
charity
(1)
checkpoints
(1)
clustering
(1)
code
(1)
columnstore index
(1)
compression
(1)
computers
(1)
configuration settings
(1)
constraints
(1)
contained databases
(1)
corruption
(1)
crystal clear
(1)
crystaldiskmark
(1)
cte
(1)
ctp1
(1)
data
(1)
data compression
(1)
data modeling
(1)
data protection european union
(1)
database diagram
(1)
database principals
(1)
database users
(1)
dba
(1)
dbcc checkdb
(1)
ddl triggers
(1)
deadlock graph trace
(1)
denali
(1)
deployment process
(1)
development
(1)
dimension
(1)
disk controller
(1)
distinct
(1)
dmv
(1)
dqs
(1)
dta
(1)
employees
(1)
error handling
(1)
error log
(1)
exceptional dba
(1)
exceptional dba awards
(1)
exchange
(1)
extended events
(1)
extended support
(1)
files and filegroups
(1)
for each task
(1)
format phone number
(1)
freeproccache
(1)
geekbench
(1)
geoflow
(1)
goals
(1)
grant
(1)
graphs
(1)
grouping sets
(1)
hashing
(1)
highavailability
(1)
hp data protector
(1)
hyper-v
(1)
i/o
(1)
i/o statistics
(1)
ide
(1)
iif
(1)
inner join
(1)
integrity
(1)
job quality
(1)
joins
(1)
json
(1)
licensing
(1)
linear gauge control
(1)
log
(1)
mainsteam support
(1)
maintenance and management
(1)
management
(1)
mcts
(1)
memory
(1)
merge
(1)
migration
(1)
misc
(1)
miscellaneous
(1)
monitoring
(1)
msde
(1)
mvp
(1)
netbook
(1)
netbooks
(1)
nolock
(1)
normalization
(1)
null
(1)
ole-db connection
(1)
orphaned
(1)
output clause
(1)
over
(1)
paritioning
(1)
partitioning
(1)
passwords
(1)
performancepoint
(1)
pivot
(1)
precedence constraints
(1)
presenting live meeting
(1)
procedure cache
(1)
productivity
(1)
query
(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)
schema
(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 azure
(1)
sql compare
(1)
sql connections
(1)
sql injection
(1)
sql server 2011
(1)
sql server hardware
(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)
syscolumns
(1)
table valued function
(1)
table valued parameters
(1)
tally table
(1)
ted kummert
(1)
test data
(1)
tim mitchell
(1)
tips
(1)
transactions
(1)
troubleshooting
(1)
try-catch
(1)
t-sql tuesday
(1)
udf
(1)
undocumented stored procedures
(1)
user defined function (udf)
(1)
user defined functions
(1)
user group
(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-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.