SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Blogs Rss

   Items 1 to 20 of 26423    Older >>
 

Understanding Data Sharing in SQL Server Docker Containers

This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers...  Read more...
By Prashanth Jayaram 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

Databases and DevOps, Tools are the Easy Part

Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...  Read more...
By Grant Fritchey 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

SQL Saturday Louisville–Bout That Time

SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this...  Read more...
By CYates 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 17 reads

Counting NULLs

Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...  Read more...
By Kenneth Fisher 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

Downtime

I was speaking at a conference recently and when I bumped into a friend, the first thing she said to...  Read more...
By Andrew Pruski 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Inline Table-Valued Functions (TVFs)

Lets start off with what is a table-valued function (TVF)? A TVF is a dynamic table produced at the time...  Read more...
By SQL_Girl 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Another MVP Award – 2018-2019

Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...  Read more...
By Dharmendra Keshari 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

SQL Agent for Azure SQL Database? Not quite

The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is...  Read more...
By Arun Sirpal 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,756 reads

What Is The Preferred Join Operator in SQL Server?

I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...  Read more...
By Grant Fritchey 2018/07/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,639 reads

Book Review – Factfulness by Hans Rosling

I recently bought the book Factfulness – Ten Reasons we’re wrong about the world – And why things are better than you...  Read more...
By Koen Verbeeck 2018/07/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

SQL Server data flow into Excel template with Power Query function-based parameter

(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a...  Read more...
By Rayis Imayev 2018/07/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

SQL Homework – July 2018 – Create a SQL Agent Job

For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...  Read more...
By Kenneth Fisher 2018/07/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,681 reads

Testing BackBlaze Restores

The most important thing for a data guy is having a way to restore data. If security, performance, etc. are...  Read more...
By Steve Jones 2018/07/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,857 reads

SQL Server : Understanding Backup and Restore operations using Docker Containers

In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers. This is certainly...  Read more...
By Prashanth Jayaram 2018/07/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

Back to #SQLSat Louisville

Next week is SQL Saturday #729 – Lousiville and I’m making the trip. This will be my third or fourth trip...  Read more...
By Steve Jones 2018/07/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 207 reads

Balancing Security Concerns.

I have a presentation I do every now again on security basics that I’m actually quite proud of. One of...  Read more...
By Kenneth Fisher 2018/07/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Why Aren’t You Using SSMS 17?

Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...  Read more...
By Grant Fritchey 2018/07/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,130 reads

MSDTC Supported Configurations

The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think.  It’s a different choice if...  Read more...
By Ryan Adams 2018/07/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,559 reads

Finding Inconsistent Key Values–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2018/07/11 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 235 reads

Performance as a feature, software developer edition

Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient...  Read more...
By Randolph West 2018/07/11 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 151 reads
   Items 1 to 20 of 26423    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)    
always on (5)    
execution plans (5)    
learning (5)    
mdx (5)    
presenting (5)    
speaking (5)    
sql in the city (5)    
sql server 2012 (5)    
sqlservercentral (5)    
statistics (data) (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 (extract, transform, and load) (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 lunch (2)    
sql server 2008 r2 (2)    
sql server 2014 (2)    
sql server architecture (2)    
sqlbits (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 group (ag) (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 trigger (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 (xe) (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 (tvf) (1)    
table valued parameters (tvp) (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 groups (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)