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

Content with tag SQL Server Rss

   Items 1 to 20 of 201    Older >>
 

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 | 3,449 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 | 3,942 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,144 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 | 1,727 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,432 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 | 2,770 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,512 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,404 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 | 662 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 | 4,764 reads

What If Week: What Would You Fix Or Change?

Brent Ozar, Erik Darling, and Tara Kizer think about what they would change or fix if they had access to SQL Server’s source code.  Read more...
By Additional Articles 2017/09/26 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,232 reads

Searching and finding a string value in all columns in a SQL Server table

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,627 reads

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?  Read more...
By Ginger Keys 2017/07/04 (first published: 2015/12/14) | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 9,620 reads

Visual Checks on How Data is Distributed in SQL Server

There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of the way that data is distributed in a column. You may think, wouldn't it be nice to have a SQL function that just showed you roughly what the distribution was, graphically, in the results pane. Phil Factor thought that was well and turned the vague wish into reality.  Read more...
By 2017/07/03 | Source: SimpleTalk | Category: sql server
Rating:  Rate this |   Briefcase | 4,882 reads

Export data from SQL Server to Excel

What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.  Read more...
By Additional Articles 2017/06/30 | Source: MSSQLTips.com | Category: excel
Rating:  Rate this |   Briefcase | 5,382 reads

Filegroup Restoring and Database Consistency

In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.  Read more...
By Bogdan SAHLEAN 2017/06/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 724 reads

PowerShell Scripting to Replicate Cloud & SaaS Data to SQL Server

Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell  Read more...
By Jerod Johnson 2017/06/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 424 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 601 reads

Building Dynamic React Apps with SQL Server Data

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.  Read more...
By Jerod Johnson 2017/04/24 | Source: SQLServerCentral.com | Category: react
Rating: |  Discuss |   Briefcase | 352 reads

Justify the Remote access requirement for Biztalk Log Shipping

This article will show why there is a need for remote access with a Biztalk server that uses log shipping.  Read more...
By Muhammad Bilal Ayub Khokhar 2017/03/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 293 reads
   Items 1 to 20 of 201    Older >>
 
Tags
blogs (28)    
t-sql (15)    
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)    
error log (3)    
excel (3)    
hashbytes() (3)    
json (3)    
performance tuning (3)    
sql server 2000 (3)    
agent jobs (2)    
articles (2)    
auditing (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 (2)    
database growth (2)    
development (2)    
etl (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)    
trivia (2)    
visual studio (2)    
windows security (2)    
xml (2)    
ado.net (1)    
alwayson availability groups (1)    
analysis (1)    
analysis services (ssas) (1)    
application design (1)    
async (1)    
autogrowth (1)    
aws (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 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)    
dba (1)    
ddl (1)    
deadlock graph (1)    
deadlocks (1)    
dependencies (1)    
disk space usage (1)    
distribution (1)    
dmo (1)    
document (1)    
dts (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)    
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)    
indexing (1)    
insert (1)    
installation (1)    
instances (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)    
openjson (1)    
organization chart (1)    
orm (1)    
orphaned users (1)    
other (1)    
paas (1)    
partition switching (1)    
partitioning (1)    
pass summit (1)    
perfmon (1)    
perfmon counters (1)    
pivottable (1)    
policy-based management (1)    
politics (1)    
porcentagem itens núcleus (1)    
ports (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)    
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)    
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 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)    
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)