Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag blogs Rss

<< Previous 20    Items 21 to 40 of 14008    Next 20 >>
 

Wait Stats – sys.dm_os_wait_stats – Monitoring and Using

sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...  Read more...
By SteveHood79 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

CREATE SCHEMA can do what?!?!?

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...  Read more...
By Kenneth Fisher 2013/05/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,365 reads

SQLSaturday Redmond(SQLSat212) – A quick recap !

That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...  Read more...
By AnupWarrier 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Getting Information from a Database using Dynamic SQL

I ran across someone that was building a restore script to automated their restores. This person wanted their script to...  Read more...
By Steve Jones 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Last Weeks Top “Reading” Links #33

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...  Read more...
By StrateSQL 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking

There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and...  Read more...
By Prashanth Jayaram 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 163 reads

SQL Server – Show/Hide Results Pane in Management Studio 2012

In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard...  Read more...
By Vishal.Gajjar 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

SQLSaturday#200 PA Event Update!

With less than two weeks to go until SQLSaturday#200 at 45 Liberty Blvd., Suite 210 Malvern, PA 19355, Malvern, PA, 19355 they're...  Read more...
By Robert Pearl 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 334 reads

Roll Logs – Backup Recovery

Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....  Read more...
By SteveHood79 2013/05/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 645 reads

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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 196 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 154 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 170 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 134 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 108 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 | 816 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 442 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 109 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 228 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 472 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/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 254 reads
<< Previous 20    Items 21 to 40 of 14008    Next 20 >>
 
Tags
career (53)    
security (46)    
t-sql (44)    
integration services (ssis) (36)    
powershell (33)    
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 (ha) (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)    
azure (4)    
conferences/user groups (4)    
databases (4)    
fundamentals (4)    
humor (4)    
maintenance plans (4)    
management studio (ssms) (4)    
mdx (4)    
professional organization for sql server (4)    
virtualization (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)    
jobs (3)    
linkedin (3)    
live meeting (3)    
log shipping (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)    
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)