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

Content with tag SQL Server Rss

   Items 1 to 20 of 236    Older >>
 

Generate documents from SQL Server

Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.   Read more...
By Murthy TS 2018/10/08 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,317 reads

Adaptive Query Processing in SQL Server

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,438 reads

The Changing Role of SQL Server Monitoring

As SQL Server estates continue to grow quickly, and change in nature, due to the ease with which new cloud-based, containerized or virtual machine-based SQL Servers can be provisioned, so too the role of the monitoring tool changes.  Read more...
By 2018/09/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,346 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2018/09/14 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 4,301 reads

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.  Read more...
By Additional Articles 2018/09/10 | Source: SimpleTalk | Category: kerberos
Rating: (not yet rated)  Rate this |   Briefcase | 3,062 reads

ISNUMERIC function

By kiran diamond 2018/09/07 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 848 reads

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.  Read more...
By Additional Articles 2018/09/07 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating:  Rate this |   Briefcase | 2,608 reads

Setting Up SQL Server: People Still Need Help

Erik points out a few things that SQL Server should offer to configure by default.  Read more...
By Additional Articles 2018/08/24 | Source: Brent Ozar Unlimited Blog | Category: setup
Rating:  Rate this |   Briefcase | 3,930 reads

How to Resize tempdb

When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.  Read more...
By Additional Articles 2018/08/21 | Source: Database Journal | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 3,799 reads

How to Check Performance on a New SQL Server

Before you go live, test your backup and CHECKDB speeds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,395 reads

Using pw-inspector in Brute Force attack on SQL Server

In this article we're going to explore the world of brute force attacks and pwd-inspector for tests with SQL Server  Read more...
By Anil Kuhat 2018/08/14 | Source: SQLServerCentral.com | Category: brute force
Rating: |  Discuss |   Briefcase | 867 reads

SQL Server Index Tutorial Overview

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.   Read more...
By Additional Articles 2018/08/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 4,208 reads

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.  Read more...
By Diogo Castro 2018/08/07 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,064 reads

Join Redgate’s SQL data catalog early access program

Redgate wants your help to develop a product for SQL Server data classification that meets today’s compliance and DevOps needs. If you’re interested in taking part in research and providing feedback on new releases, please register for the early access program.   Read more...
By 2018/08/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,882 reads

Getting Started with Database Development Using SQL Provision

Steve Jones shows how a developer, who is a sysadmin on their own SQL Server instance, can migrate their existing development databases to clones, using SQL Provision. Using a simple PowerShell function, we have seen a repeatable process that is quick and consistent.  Read more...
By 2018/07/30 | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,701 reads

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.  Read more...
By Additional Articles 2018/07/30 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 3,591 reads

Placing a Mark in SQL Server's Transaction Log for Fall Back

How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.  Read more...
By Additional Articles 2018/07/24 | Source: Database Journal | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,019 reads

Why SQL Developers Keep Making The Same Mistakes

They learned by reading your old code.  Read more...
By Additional Articles 2018/07/20 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,980 reads

Fixing ‘A required Privilege is not held by client’ Error

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out . A required privilege is not held by the client. The step failed.   Read more...
By Vishnu Gupthan 2018/07/16 | Source: SQLServerCentral.com | Category: required privilege
Rating: |  Discuss |   Briefcase | 384 reads

What to Do When SQL Server is Slow

Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.  Read more...
By Additional Articles 2018/07/13 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 5,761 reads
   Items 1 to 20 of 236    Older >>
 
Tags
blogs (28)    
t-sql (16)    
editorial (14)    
administration (10)    
integration services (ssis) (10)    
powershell (10)    
cloud services (8)    
security (8)    
editorial - mp3 (7)    
editorial - wmv (7)    
patrick leblanc (7)    
editorial - ipod (6)    
reporting services (ssrs) (6)    
database weekly (5)    
oracle (5)    
sql server 2005 (5)    
sql server 2008 (5)    
database security (4)    
databases (4)    
json (4)    
learning (4)    
microsoft (4)    
tools (4)    
xml (4)    
c# (3)    
change tracking (3)    
checksum (3)    
data warehousing (3)    
database (3)    
error log (3)    
excel (3)    
hashbytes() (3)    
indexing (3)    
performance tuning (3)    
sql server 2000 (3)    
agent jobs (2)    
articles (2)    
auditing (2)    
aws (2)    
azure sql database (2)    
backup and restore (2)    
binary_checksum (2)    
books (2)    
business intelligence (2)    
change data capture (cdc) (2)    
change detection (2)    
clustering (2)    
conflict resolution (2)    
data privacy and protection (2)    
database growth (2)    
development (2)    
etl (extract, transform, and load) (2)    
fundamentals (2)    
initial size (2)    
ip addresses (2)    
live meeting (2)    
management data warehouse (2)    
memory (2)    
migration (2)    
mssql (2)    
presenting (2)    
r language (2)    
rowversion (2)    
san (2)    
scripting (2)    
speaking (2)    
sql audit (2)    
sql server 2012 (2)    
storage (2)    
stored procedures (2)    
tempdb (2)    
trivia (2)    
upgrading (2)    
visual studio (2)    
windows security (2)    
xquery (2)    
a required privilege (1)    
adaptive query processing (1)    
ado.net (1)    
agent job fail (1)    
amazon (1)    
analysis (1)    
analysis services (ssas) (1)    
application design (1)    
async (1)    
autogrowth (1)    
automatic tuning (1)    
automation (1)    
availability group (ag) (1)    
azure (1)    
backup (1)    
bacpac (1)    
baseline (1)    
bcp command (1)    
best practice (1)    
big data (1)    
biztalk log shipping (1)    
brute force (1)    
career (1)    
cdata (1)    
cdc (1)    
change foreign key name (1)    
checkout (1)    
cloud (1)    
cloud computing (1)    
cluster (1)    
cms (1)    
code reuse (1)    
code review (1)    
columnstore index (1)    
command line install (1)    
compliance (1)    
conferences and events (1)    
conferences/user groups (1)    
configuration (1)    
consolidation (1)    
constraints (1)    
consultancy (1)    
corruption (1)    
cpu (1)    
ct (1)    
data analysis (1)    
data collector (1)    
data encryption (1)    
data quality services (dqs) (1)    
database administration (1)    
database design (1)    
database users (1)    
datamate technology (1)    
date (1)    
datediff (1)    
dba (1)    
ddl (1)    
deadlock graph (1)    
deadlocks (1)    
default settings (1)    
dependencies (1)    
devops (1)    
disk space usage (1)    
distribution (1)    
dmo (1)    
document (1)    
documents (1)    
dts (1)    
ec2 (1)    
english query (1)    
enterprise edition (1)    
environment variables (1)    
error handling (1)    
event log (1)    
exchange (1)    
export data (1)    
export to excel (1)    
export with column headers (1)    
extract, transform, load (etl) (1)    
file copy (1)    
filegroup (1)    
filestream (1)    
for xml (1)    
foreign keys (fk) (1)    
friday poll (1)    
geo database (1)    
glm (1)    
gmsa (1)    
google (1)    
graph databases (1)    
graphs (1)    
group managed service accounts (1)    
growth rates (1)    
handle (1)    
hard disk (1)    
health check (1)    
healthcheck (1)    
hibernate (1)    
hierarchy (1)    
html (1)    
hydra (1)    
identity property (1)    
insert (1)    
installation (1)    
instances (1)    
instant file initialization (ifi) (1)    
introduction (1)    
io (1)    
ironpython (1)    
is not held by the client (1)    
isnumeric (1)    
japanese character (1)    
job trends (1)    
kerberos (1)    
linear gauge control (1)    
linux (1)    
master data services (mds) (1)    
mdw (1)    
microsoft azure (1)    
microsoft sql server (1)    
miscellaneous (1)    
msde (1)    
multi threaded (1)    
mysql (1)    
naming convention (1)    
netapp (1)    
neural network (1)    
new feature of sql server 2008 (1)    
nitesh dedhia (1)    
node (1)    
not held by client (1)    
notification services (1)    
openjson (1)    
organization chart (1)    
orm (1)    
orphaned users (1)    
other (1)    
paas (1)    
partition switching (1)    
partitioning (1)    
pass summit (1)    
patches (1)    
pdf (1)    
perfmon (1)    
perfmon counters (1)    
performance analysis (1)    
performance and tuning (1)    
pivottable (1)    
policy-based management (1)    
politics (1)    
porcentagem itens núcleus (1)    
ports (1)    
power bi (1)    
powershell scheduling jobs (1)    
primary key (pk) (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
ptvs (1)    
pwd-inspector (1)    
python (1)    
python tools (1)    
query optimizer (1)    
query performance (1)    
query store (1)    
r services (1)    
rateio itens (1)    
rateio nucleus (1)    
rateio produtos (1)    
r-bar (1)    
rds (1)    
react (1)    
referential integrity (1)    
regression (1)    
remote access (1)    
rename primary key (1)    
replication (1)    
replication tracking (1)    
report builder (1)    
required privilege (1)    
resource governor (1)    
restart (1)    
restore (1)    
rm núcleus (1)    
schedule powershell jobs (1)    
schedule powershell jobs using sql agent (1)    
schema swapping (1)    
scr (1)    
search (1)    
sequence (1)    
service broker (sssb) (1)    
setup (1)    
sheet (1)    
silent install (1)    
smo (1)    
snapmanager for sql (1)    
split delimited string. (1)    
split string (1)    
spn (1)    
sql login using powershell (1)    
sql mail (1)    
sql migrator (1)    
sql monitoring (1)    
sql on linux (1)    
sql provision (1)    
sql saturday (1)    
sql search (1)    
sql server 2008 r2 (1)    
sql server 2014 (1)    
sql server 2016 (1)    
sql server architecture (1)    
sql university (1)    
sql2016 (1)    
sqlclr (1)    
sqlsaturday (1)    
statistics (1)    
surface area configuration tool (1)    
synchronization (1)    
systemhealth (1)    
task manager (1)    
the step failed. (1)    
tim mitchell (1)    
totvs rm (1)    
training (1)    
transaction log (1)    
tree structure (1)    
triggers (1)    
troubleshooting (1)    
udf (1)    
unattended install (1)    
unicode character (1)    
uninstall (1)    
user groups (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
web services (1)    
windows (1)    
windows login (1)    
word (1)    
xevents (1)    
yaml (1)