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

Content with tag SQL Server Rss

   Items 1 to 20 of 242    Older >>
 

How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.  Read more...
By Additional Articles 2018/12/07 | Source: Brent Ozar Unlimited Blog | Category: memory
Rating: (not yet rated)  Rate this |   Briefcase | 3,424 reads

SQL Server Auditing for HIPAA and SOX – Part 4

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.  Read more...
By Additional Articles 2018/11/27 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,039 reads

How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.  Read more...
Rating:  Rate this |   Briefcase | 3,046 reads

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here.  Read more...
By 2018/11/22 (first published: 2018/11/16) | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here.  Read more...
By 2018/11/22 (first published: 2018/11/16) | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

Spotting Unauthorized Configuration Settings in SQL Server

In this article, Phil Factor explains how to detect any changes in server or database configuration settings, using Extended Events, and a custom metric, in SQL Monitor. He’ll then refine the technique to report on unauthorized drift in the value of these settings, by storing the officially agreed values in an extended property and comparing them to the current values.  Read more...
By 2018/10/25 | Source: Redgate | Category: configuration settings
Rating: (not yet rated)  Rate this |   Briefcase | 2,432 reads

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,387 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,572 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,469 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,355 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,197 reads

ISNUMERIC function

By kiran diamond 2018/09/07 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 879 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,733 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 | 4,192 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,924 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,525 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 | 871 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,326 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,103 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,992 reads
   Items 1 to 20 of 242    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)    
auditing (3)    
c# (3)    
change tracking (3)    
checksum (3)    
data warehousing (3)    
database (3)    
error log (3)    
excel (3)    
hashbytes() (3)    
indexing (3)    
memory (3)    
performance tuning (3)    
sql server 2000 (3)    
agent jobs (2)    
articles (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)    
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)    
check constraints (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)    
configuration settings (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)    
hipaa (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)    
missing index (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)    
prize draw (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
ptvs (1)    
pwd-inspector (1)    
python (1)    
python tools (1)    
queries (1)    
query data store (qds) (1)    
query optimizer (1)    
query performance (1)    
r services (1)    
rateio itens (1)    
rateio nucleus (1)    
rateio produtos (1)    
r-bar (1)    
rds (1)    
react (1)    
redgate software (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)    
sarbanes-oxley (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)    
survey (1)    
synchronization (1)    
sys admin (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)