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

Content with tag SQL Server Rss

   Items 1 to 20 of 211    Older >>
 

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.  Read more...
By Additional Articles 2018/05/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,807 reads

Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.   Read more...
By Vishnu Gupthan 2018/05/22 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 655 reads

Why Are You Dropping and Recreating Your Indexes?

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?  Read more...
By Additional Articles 2018/05/22 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 3,620 reads

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.  Read more...
By Kenneth Igiri 2018/04/12 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 764 reads

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...
By David Strack 2018/04/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,314 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,729 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,729 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,729 reads

How to Turn on Instant File Initialization

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.  Read more...
By Additional Articles 2018/01/03 | Source: Database Journal | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,215 reads

Still More SQL Server Features that Time Forgot

As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.  Read more...
By Additional Articles 2017/12/20 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,484 reads

Importing JSON Data from Web Services and Applications into SQL Server

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.  Read more...
By Additional Articles 2017/12/04 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 4,121 reads

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.  Read more...
By Additional Articles 2017/12/01 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,781 reads

More SQL Server Features that Time Forgot

SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.  Read more...
By Additional Articles 2017/11/21 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,485 reads

Importing Historical Stock Prices from Yahoo Finance into SQL Server

Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.  Read more...
By Additional Articles 2017/11/20 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,099 reads

Cleanly Uninstalling Stubborn SQL Server Components

There is a built-in command called msiexec which has an uninstall parameter (-x). This command can be used to remove stubborn programs through brute force. First, though, you need to get an inventory of the GUIDs that represent the programs you need to remove.   Read more...
By Additional Articles 2017/11/16 | Source: MSSQLTips.com | Category: uninstall
Rating: (not yet rated)  Rate this |   Briefcase | 2,623 reads

Consuming hierarchical JSON documents in SQL Server using OpenJSON

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.  Read more...
By Additional Articles 2017/11/15 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 3,137 reads

How to Do a Free SQL Server Health Check

Brent Ozar shares a free script that that you can run to quickly produce a health check of your SQL Server.  Read more...
By Additional Articles 2017/11/14 | Source: Brent Ozar Unlimited Blog | Category: health check
Rating: (not yet rated)  Rate this |   Briefcase | 4,923 reads

The SQL Server Features that Time Forgot

Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well, amongst the marketing people anyway. What happens to all the exciting TLAs that are bandied about when a new version launches? It's mixed, it seems. Adam Machanic's classic post, The SQL Hall of Shame, has inspired Rob Sheldon to look back at some of the features that, though worthy, have may have failed to hit the mainstream.  Read more...
By Additional Articles 2017/10/27 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 5,731 reads

Group Managed Service Accounts (gMSAs) in SQL2016

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON  Read more...
Rating: |  Discuss |   Briefcase | 730 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.  Read more...
By Additional Articles 2017/09/28 | Source: SimpleTalk | Category: json
Rating:  Rate this |   Briefcase | 5,720 reads
   Items 1 to 20 of 211    Older >>
 
Tags
blogs (28)    
t-sql (16)    
editorial (14)    
administration (10)    
powershell (10)    
integration services (ssis) (9)    
cloud services (8)    
editorial - mp3 (7)    
editorial - wmv (7)    
patrick leblanc (7)    
security (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)    
learning (4)    
microsoft (4)    
tools (4)    
c# (3)    
change tracking (3)    
checksum (3)    
data warehousing (3)    
database (3)    
error log (3)    
excel (3)    
hashbytes() (3)    
json (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)    
business intelligence (2)    
change data capture (cdc) (2)    
change detection (2)    
clustering (2)    
conflict resolution (2)    
database growth (2)    
development (2)    
etl (2)    
fundamentals (2)    
indexing (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)    
trivia (2)    
visual studio (2)    
windows security (2)    
xml (2)    
ado.net (1)    
amazon (1)    
analysis (1)    
analysis services (ssas) (1)    
application design (1)    
async (1)    
autogrowth (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)    
books (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)    
conferences and events (1)    
conferences/user groups (1)    
configuration (1)    
consolidation (1)    
constraints (1)    
consultancy (1)    
cpu (1)    
ct (1)    
data analysis (1)    
data collector (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)    
dependencies (1)    
disk space usage (1)    
distribution (1)    
dmo (1)    
document (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)    
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)    
identity property (1)    
insert (1)    
installation (1)    
instances (1)    
instant file initialization (ifi) (1)    
introduction (1)    
io (1)    
ironpython (1)    
japanese character (1)    
job trends (1)    
linear gauge control (1)    
linux (1)    
master data services (mds) (1)    
mdw (1)    
memory (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)    
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)    
perfmon (1)    
perfmon counters (1)    
pivottable (1)    
policy-based management (1)    
politics (1)    
porcentagem itens núcleus (1)    
ports (1)    
powershell scheduling jobs (1)    
primary key (pk) (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
ptvs (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)    
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)    
sheet (1)    
silent install (1)    
smo (1)    
snapmanager for sql (1)    
split delimited string. (1)    
split string (1)    
sql login using powershell (1)    
sql mail (1)    
sql migrator (1)    
sql on linux (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)    
tempdb (1)    
tim mitchell (1)    
totvs rm (1)    
training (1)    
tree structure (1)    
triggers (1)    
troubleshooting (1)    
udf (1)    
unattended install (1)    
unicode character (1)    
uninstall (1)    
upgrade (1)    
upgrading (1)    
user groups (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
web services (1)    
windows (1)    
windows login (1)    
xevents (1)    
xquery (1)    
yaml (1)