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

<< Newer    Items 61 to 80 of 16544    Older >>
 

Historical Stock Prices and Volumes from Python to a CSV File

Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.  Read more...
By Additional Articles 2018/01/31 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,547 reads

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...
By Daniel Calbimonte 2018/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 205 reads

Lowering the Noise

We are busy as administrators, and it can be very useful to ensure our systems avoid adding to our workload.  Read more...
By Steve Jones 2018/01/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Network Issue or THREADPOOL waits?

Tara Kizer talks identifying THREADPOOL waits and what you can do about them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,824 reads

The 2018 State of Database DevOps report

In this year's survey, over 700 IT professionals across a range of sectors, in organizations of every size around the globe were asked about their plans to adopt DevOps, how they thought the database fitted into the picture, and what they thought the biggest challenges were.  Read more...
By 2018/01/30 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 2,394 reads

Sending table form HTML emails from a SQL Server database engine

The solution which helps to smiplify delivery of a table content in the HTML form using Database mail  Read more...
By Evgeny Garaev 2018/01/29 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 1,343 reads

IoT Increases Efficiency

IoT can help us better manage our world.  Read more...
By Steve Jones 2018/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

How do the Experts Become Experts?

How does one become better at some endeavor?  Read more...
By Kathi Kellenberger 2018/01/29 | Source: SQLServerCentral.com | Category: editorials
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

SQL Server Machine Learning Services – Part 3: Plotting Data with Python

One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis of data. Robert Sheldon demonstrates matplotlib, a 2D plotting library, widely used with Python to create quality charts.  Read more...
By Additional Articles 2018/01/29 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 3,185 reads

The top 7 business benefits of establishing DevOps in your organization

Any change within an organization requires an investment of time, expertise and money. Therefore, it is natural that leaders should assess the potential of DevOps in terms of what it will deliver: Managers should ask the question: What is to be gained by changing our current way of doing things?  Read more...
By 2018/01/29 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,354 reads

How to Upgrade SQL Server

What steps should you take in upgrading SQL Server to SQL 2014  Read more...
By Rudy Panigas 2018/01/26 (first published: 2015/10/15) | Source: SQLServerCentral.com | Category: sql server upgrade
Rating: |  Discuss |   Briefcase | 6,470 reads

How Can DevOps Concepts Provide Value in Digital Transformation Projects?

For some of us, DevOps means startups, cloud, fast-moving social media applications and Extreme Programming (XP). What about large corporate IT initiatives, Digital Transformation projects, and business process re-engineering? Can DevOps be relevant and appropriate? Mohammad Rizvi argues from experience that it most certainly can be.  Read more...
By 2018/01/26 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,534 reads

Are You Always Up?

This week Steve discusses uptime, RPO and RTO.  Read more...
By Steve Jones 2018/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

The Database DevOps Challenges SQL Clone Solves

With its PowerShell integration, SQL Clone becomes an important component in a broader database DevOps toolchain - Tony Davis explains in detail.  Read more...
By 2018/01/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,242 reads

Adaptive Query Processing – Batch Mode Adaptive Join

Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators  Read more...
Rating: |  Discuss |   Briefcase | 724 reads

Create Size Based Backups for SQL Server 2017

Microsoft has never documented how the database log works, such as its format, its logging mechanism/algorithm, etc. But SQL Server 2017 has introduced a few improvements in some DMVs that expose more details about the status of data and log changes, and we can use the new information to design a better backup strategy.  Read more...
By 2018/01/25 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 2,971 reads

Are You Patched?

With bugs in modern CPUs, are you patching your systems?  Read more...
By Steve Jones 2018/01/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

Finding code smells using SQL Prompt: the SET NOCOUNT problem

SQL Prompt implements two static code analysis rules to check code for potential misuse of the SET NOCOUNT command. In this post, Phil Factor explains the issue.  Read more...
By 2018/01/25 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,553 reads

Effectiveness

Today Steve Jones notes that your software should handle the load and work, but it needs to get done as well.  Read more...
By Steve Jones 2018/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 188 reads

Stairway to Database Design Level 7: Triggers

In levels one to four, we built the tables, base and virtual, of a schema. Levels five and six dealt with stored procedures. This level deals with a feature you need to avoid as much as possible; this is article is on Triggers.  Read more...
By Joe Celko 2018/01/24 (first published: 2011/09/30) | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,607 reads
<< Newer    Items 61 to 80 of 16544    Older >>