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 17763    Older >>
 

Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP...  Read more...
By 2014/10/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,565 reads

Eliminate Overlapping Dates

I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...  Read more...
By g00p3 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads

The Murder Train is making a stop in Salt Lake City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...  Read more...
By Wayne Sheffield 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 90 reads

What will you see at SQL in the City

London, Oct 24, 2014 Seattle, Nov 3, 2014 Come join us. Filed under: Blog Tagged: Humor, syndicated  Read more...
By Steve Jones 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 143 reads

Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)

Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go...  Read more...
By Andy Warren 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 212 reads

SSRS report rendered in EXCELOPENXML then something went missing

Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...  Read more...
By Rayis Imayev 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 162 reads

Learning Options in Seattle Next Month

The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...  Read more...
By Steve Jones 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Creating a SharePoint Server Farm on Azure from the Gallery

As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help...  Read more...
By DataOnWheels 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 124 reads

Analytics Platform System (APS) AU2 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2),...  Read more...
By 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Query Performance Tuning in SQL Server

I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...  Read more...
By Grant Fritchey 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Insufficient Space to Create Databases For SCOM 2012 R2

Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...  Read more...
By Andy Warren 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are...  Read more...
By Kenneth Fisher 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 266 reads

Introduction of Triggers in SQL Server

Triggers are the database objects that are used in relational databases. These are executed or fired automatically, when DDL or...  Read more...
By zorastalin 2014/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,084 reads

PASS SQL Saturday Events: November 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...  Read more...
By 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 118 reads

Webinar Q&A: SSRS Subscriptions and Data Alerts

Updated 10-16-2014 at 11:20 AM Eastern Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the...  Read more...
By Bradley Schacht 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

I'm an MVP

Hello Dear Reader!  Two weeks ago I was very honored to be named a Microsoft SQL Server MVP.  Since then...  Read more...
By SQLBalls 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

Upcoming conferences end of 2014: Microsoft Technical Server Summit, MVP Summit, PASS Summit, Microsoft Technical Summit

  (DE) Das Jahresende nähert sich in raschen Schritten. In den nächsten 3 Monaten stehen wieder mehrere Konferenzauftritte an. (EN) The end...  Read more...
By Andreas.Wolter 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 405 reads

SSIS Pivot makes you stronger

At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10...  Read more...
By Rayis Imayev 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

PASS Election Results for 2014

The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the...  Read more...
By Andy Warren 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Lync 2013 Video Issues on Windows 8

Part of the reason I have a blog is to document issues and resolutions I do not want to forget....  Read more...
By DataOnWheels 2014/10/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads
<< Newer    Items 21 to 40 of 17763    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)