Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Blogs Rss

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

Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed

Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change...  Read more...
By Kapil Singh 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 118 reads

ReadyRoll and Octopus Deploy Webinar

I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate...  Read more...
By Steve Jones 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 149 reads

Great Value IT Training - 21st July

As I have mentioned in previous posts, we have done a deal with Learning Tree to be able to offer...  Read more...
By David Postlethwaite 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Join me at SQL Saturday 531, Louisville, KY

So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday...  Read more...
By 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 128 reads

Day 2: Agile Fundamentals: Scrum, Kanban, Lean and XP

It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban,...  Read more...
By David Postlethwaite 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

Common Table Expression, Just a Name

The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...  Read more...
By Grant Fritchey 2016/07/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,307 reads

Growth or Control – #sqlpass

I’m disturbed. I read an announcement from the PASS organization this week that bothers me. I am less upset with the...  Read more...
By Steve Jones 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 188 reads

Remove-SQLDatabaseSafely My First Contribution to DBATools

What is DBA Tools? A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...  Read more...
By Rob Sewell 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads

Deploying Dynamic Data Masking Changes

I wrote a short piece over on the Redgate blog that covers how SQL Compare can catch and build a...  Read more...
By Steve Jones 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 124 reads

Use PowerShell to automate your Azure DB creation

Why create your databases manually if you don’t have to?  If there is one thing that I hate to do...  Read more...
By jphillips 46546 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 162 reads

Multi-tenant databases in the cloud

For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...  Read more...
By 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 141 reads

The new SQL Server Management Studio

Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...  Read more...
By Andrew Pruski 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 454 reads

Want to be able to read your database between restores?

When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...  Read more...
By Kenneth Fisher 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 213 reads

Day 1: Agile Fundamentals: Scrum, Kanban, Lean and XP

It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum,...  Read more...
By David Postlethwaite 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 162 reads

SSRS 2016 Book Nearly Done… My Brain is now Jell-O

(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content...  Read more...
By pturley 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Whoisactive capturing a SQL server queries Performance Tuning

  Whoisactive stored procedure is a powerful script to capture the SQL server queries with tons of information. It’s written by...  Read more...
By MUTHUKKUMARAN KALIYAMOORTHY 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,734 reads

Power BI Custom Visuals Class (Module 08 – Dot Plot)

In this module you will learn how to use the Dot Plot Power BI Custom Visual.  The Dot Plot is...  Read more...
By Devin Knight 2016/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 987 reads

Extended Event Help Queries

Enjoy this article re-publication from my original work at SQL Solutions Group. When working with Extended Events, there are times when...  Read more...
By Jason Brimhall 2016/07/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 187 reads

SQL – MultiServer SQL Inventory – PowerShell

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...  Read more...
By Prashanth Jayaram 2016/07/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads

Adding the ReadyRoll Extension in VSTS

As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product. A few...  Read more...
By Steve Jones 2016/07/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads
<< Newer    Items 21 to 40 of 21618    Older >>
 
Tags
career (61)    
security (53)    
t-sql (49)    
integration services (ssis) (38)    
powershell (35)    
backup and restore (29)    
reporting services (ssrs) (29)    
sql server (28)    
performance tuning (23)    
hardware (19)    
administration (18)    
analysis services (ssas) (18)    
networking (18)    
events (14)    
professional development (13)    
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)    
agent jobs (4)    
conferences/user groups (4)    
database design (4)    
databases (4)    
excel (4)    
fundamentals (4)    
maintenance plans (4)    
management studio (ssms) (4)    
master data services (mds) (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)    
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 log (3)    
t-sql tuesday (3)    
windows security (3)    
business intelligence (2)    
cte (2)    
data warehousing (2)    
date manipulation (2)    
dbcc (2)    
deadlocks (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)    
azure sql database (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 (ci) (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 (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 users (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 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)