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 14219    Next 20 >>
 

PASS Data Architecture VC presents Steve Simon–Challenges Designing Finance Data Warehouse

Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing...  Read more...
By Thomas LeBlanc 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

Tracing Introduction

SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...  Read more...
By SteveHood79 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Reblog: June 7 to June 13

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...  Read more...
By StrateSQL 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 153 reads

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for Pragmatic Works.  There were over 500 attendees!  The abstract...  Read more...
By 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

Few thoughts and updates

Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval. There is a reason behind...  Read more...
By Ramkumar (LivingForSQLServer) 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Colorado SQL Events : June 2013

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...  Read more...
By 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads

Improving performance by using SET STATISTICS IO

When I started using SQL Server the company I was working for at the time had no skill in this...  Read more...
By Richard Douglas 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,497 reads

T-SQL Tuesday #43 – Plan Operators

This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!)....  Read more...
By Wayne Sheffield 2013/06/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 649 reads

The Side Effect of NOLOCK (video)

A while back I put together a blog post on the side effect of NOLOCK.  Today I thought I’d push...  Read more...
By StrateSQL 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Security Questions: Migrate Logins Between Servers

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...  Read more...
By StrateSQL 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Levels in IT consultancy

The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...  Read more...
By 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Book Review: Instant Creating Data Models with PowerPivot How-to

I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...  Read more...
By pturley 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Why should we upgrade off of SQL Server 2000?

But, it still works FINE… A good many companies still have servers chugging along on SQL Server 2000 (or even, as...  Read more...
By Jen McCown 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Update Your Audit Queries for SQL Server

I was working with an auditor today who is working through a system with an external audit agency. The external...  Read more...
By 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 213 reads

Virtual SQL Playground Adventure: Introduction

Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure? An adventure is an exciting or unusual experience; it may...  Read more...
By MarlonRibunal 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 269 reads

Best practice recommendations for writing Dynamic SQL

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...  Read more...
By Kenneth Fisher 2013/06/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,847 reads

xVelocity Columnstore Indexes in SQL Server 2012

With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...  Read more...
By Basit Aalishan Masood-Al-Farooq 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise

SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...  Read more...
By Basit Aalishan Masood-Al-Farooq 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

SQL Server Transactions and Locking (Part 2)

Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...  Read more...
By Basit Aalishan Masood-Al-Farooq 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

SQLCMD – Explicit and Implicit calls – Examples

The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....  Read more...
By Prashanth Jayaram 2013/06/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads
<< Previous 20    Items 21 to 40 of 14219    Next 20 >>
 
Tags
career (53)    
security (50)    
t-sql (46)    
integration services (ssis) (37)    
powershell (33)    
reporting services (ssrs) (28)    
sql server (28)    
performance tuning (23)    
networking (18)    
administration (17)    
analysis services (ssas) (17)    
backup / recovery (16)    
hardware (16)    
professional development (13)    
events (12)    
pass (12)    
sql server 2008 (12)    
backup / restore (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)    
azure (6)    
book reviews (6)    
data mining (6)    
database security (6)    
high availability (ha) (6)    
leadership (6)    
xml (6)    
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)    
database design (4)    
databases (4)    
execution plans (4)    
fundamentals (4)    
humor (4)    
maintenance plans (4)    
management studio (ssms) (4)    
mdx (4)    
performance (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)    
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)    
date manipulation (2)    
dbcc (2)    
deadlock (2)    
etl (2)    
excel (2)    
filegroups (2)    
hard disk (2)    
host bus adapter (2)    
hyper-v (2)    
job trends (2)    
logins (2)    
master data services (mds) (2)    
misc (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)    
t-sql tuesday (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)    
dac (1)    
data (1)    
data compression (1)    
data modeling (1)    
data protection european union (1)    
database diagram (1)    
database mail (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)    
dynamic sql (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)    
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)    
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)    
parallelism (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)    
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.