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

Content with tag Blogs Rss

   Items 1 to 20 of 19747    Older >>
 

Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations

One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...  Read more...
By roman.horolskiy 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 18 reads

Speaker of the Month: September 2015

Feast or famine. The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...  Read more...
By Grant Fritchey 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 21 reads

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...  Read more...
By Jason Brimhall 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Hekaton Part 5: Introduction to Indexes in "In Memory Tables"

After a short little break on Hekaton series, we are now back with the 5th post. Two new index types...  Read more...
By 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

As I noted in my previous post, I am not a fan of scripting. In that post we set up...  Read more...
By DataOnWheels 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 445 reads

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that...  Read more...
By dustinryan 2015/09/04 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,003 reads

Executing DBCC for SQL Server Analysis Services 2016

In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...  Read more...
By dustinryan 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Growing Pains for the Networking Dinner

A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the...  Read more...
By Steve Jones 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 128 reads

SSIS – Unexpected Termination

I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...  Read more...
By Koen Verbeeck 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Viewing Running XEvent Metadata

In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...  Read more...
By Jason Brimhall 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

SQL Server 2014 Buffer Pool Extension part 3: system monitoring

In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...  Read more...
By roman.horolskiy 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Outlier Detection with SQL Server, part 7: Cook’s Distance

By Steve Bolton[ …………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the...  Read more...
By SQLServerSteve 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 885 reads

Automatic Roll Forward Transaction Log Backups

Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...  Read more...
By eitan 35333 2015/09/03 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 906 reads

Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)

Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have decided to write a...  Read more...
By Niko Neugebauer 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Know About Temporal Tables in SQL Server 2016

Temporal tables were included in SQL Server 2016 as a new feature. These temporal tables are also known as system-versioned...  Read more...
By zorastalin 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 387 reads

SQL Server Page Level Corruption And Resolution

SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain...  Read more...
By zorastalin 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

An Evening of Networking at the 2015 PASS Summit on October 26, 2015 (Monday)

Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new...  Read more...
By Andy Warren 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really...  Read more...
By Ed Elliott 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

Checking for Excessive Permissions in SQL Server - WaterOx Consulting

Who can do what? One of the key things that a DBA... The post Checking for Excessive Permissions in SQL Server...  Read more...
By WaterOx 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 128 reads

Upcoming Presentation – Space Coast SQL/.Net User Group

If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to...  Read more...
By Bradley Schacht 2015/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads
   Items 1 to 20 of 19747    Older >>
 
Tags
career (61)    
security (53)    
t-sql (49)    
integration services (ssis) (38)    
powershell (35)    
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)    
humor (6)    
interviews (6)    
leadership (6)    
sql saturday (6)    
alwayson (5)    
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)    
conferences/user groups (4)    
database design (4)    
databases (4)    
excel (4)    
fundamentals (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)    
redgate 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 (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)    
schemas (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)