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

Content with tag Blogs Rss

<< Newer    Items 21 to 40 of 18111    Older >>
 

Exam Prep 70-463: SSIS Connection Managers

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2014/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,492 reads

Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP

Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...  Read more...
By Niko Neugebauer 2014/12/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the...  Read more...
By Steve Jones 2014/12/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...  Read more...
By Guy Glantser 2014/12/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Making a Change Log Easier With PowerShell

Having a Change Log is a good thing. A quick and simple place to find out what has changed on...  Read more...
By Rob Sewell 2014/12/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,428 reads

Rebuilding and Reorganizing Clustered Columnstore Indexes

Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...  Read more...
By Matan_Yungman 2014/12/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,396 reads

RegEx Those Dates

Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....  Read more...
By Steve Jones 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 268 reads

Why You Should Benchmark Your Storage

You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And...  Read more...
By kleegeek 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 238 reads

Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...  Read more...
By Jen McCown 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 169 reads

The Value of Writing Good

Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re...  Read more...
By Tracy McKibben 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

DBTA – Microsoft SQL Server and the Big Data Play

  When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider...  Read more...
By 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought...  Read more...
By Kenneth Fisher 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads

SQL Server Disk Space Emergencies

One of the things I’ll see happen often with SQL Server instances is that the system will run out of...  Read more...
By Steve Jones 2014/12/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,334 reads

SSAS #39–Building Optimal and Well-Tuned Dimensions

The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...  Read more...
By Sherry Li's BI Corner 2014/12/14 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Little Java Boy

I didn’t want to repeat the Night Before Upgrade again this year, so I wrote something knew. Go ahead, sing...  Read more...
By Tracy McKibben 2014/12/14 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

SSIS #117–What is the Location in the MSOLAP Connection String

MSOLAP is a native OLE DB provider for Analysis Services A common task during ETL is to process the OLAP dimensions and the...  Read more...
By Sherry Li's BI Corner 2014/12/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Azure Columnstore, part 1 – The initial preview offering

With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...  Read more...
By Niko Neugebauer 2014/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 6 reads

We’ve Got to Do More With Less

  “We’ve got to do more with less.” A few years ago that phrase was tossed about regularly in companies throughout...  Read more...
By 2014/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

Reblog: December 5 to December 11

Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just...  Read more...
By StrateSQL 2014/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Friday Followup For December 12, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...  Read more...
By Tracy McKibben 2014/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads
<< Newer    Items 21 to 40 of 18111    Older >>
 
Tags
career (61)    
security (53)    
t-sql (49)    
integration services (ssis) (38)    
powershell (34)    
reporting services (ssrs) (29)    
sql server (28)    
performance tuning (23)    
hardware (19)    
administration (18)    
analysis services (ssas) (18)    
networking (18)    
backup / recovery (17)    
events (14)    
professional development (13)    
backup / restore (12)    
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)    
interviews (6)    
leadership (6)    
sql saturday (6)    
execution plans (5)    
learning (5)    
mdx (5)    
presenting (5)    
speaking (5)    
sql in the city (5)    
sql server 2012 (5)    
sqlservercentral (5)    
statistics (5)    
storage (5)    
virtualization (5)    
alwayson (4)    
conferences/user groups (4)    
database design (4)    
databases (4)    
excel (4)    
fundamentals (4)    
humor (4)    
jobs (4)    
maintenance plans (4)    
management studio (ssms) (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)    
master data services (mds) (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 logs (3)    
t-sql tuesday (3)    
windows security (3)    
business intelligence (2)    
cte (2)    
data warehousing (2)    
date manipulation (2)    
dbcc (2)    
deadlock (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)    
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 2014 (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)    
automation (1)    
availability (1)    
availability groups (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 (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 trace (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 (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 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 (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)    
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 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 (1)    
table valued parameters (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 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)