SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/10/01 to 2018/10/08

SQL Server Cursor Example

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them..  Read more...
By Additional Articles 2018/10/08 | Source: MSSQLTips.com | Category: cursor
Rating: (not yet rated)  Rate this |   Briefcase | 2,951 reads

Power BI Introduction: Publishing Reports to the Power BI Service — Part 8

Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.  Read more...
By Additional Articles 2018/10/08 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,609 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,294 reads

6 DBA Lessons I Wish Someone Would Have Taught Me Earlier

The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.  Read more...
By Additional Articles 2018/10/05 | Source: Brent Ozar Unlimited Blog | Category: dba tips
Rating:  Rate this |   Briefcase | 5,043 reads

Redgate's Estate Management Research Survey

Redgate invites you to take their Estate Management Research Survey. Their aim for this questionnaire is to gather some information around the importance of certain tasks within the wider umbrella of ‘Estate Management’ and your satisfaction with your current solutions to them. The survey should take around 10 minutes to complete. Help them continue to support and build relevant tools to help you in your job and in recognition of you taking time to help us, they will award an Amazon voucher or equivalent to the value of $50 to one lucky survey participant. This will be determined in early October 2018.  Read more...
By 2018/10/05 (first published: 2018/09/27) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,930 reads

In-Memory OLTP Table Checkpoint Processes Performance Comparison

The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"  Read more...
By Nagaraj Venkatesan 2018/10/05 (first published: 2015/10/27) | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 3,274 reads

Insert missing SQL Server IDENTITY column values using SET IDENTITY_INSERT command

In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command.  Read more...
By Additional Articles 2018/10/04 | Source: MSSQLTips.com | Category: identity property
Rating:  Rate this |   Briefcase | 2,705 reads

Using Azure Storage Explorer

Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azure Storage .NET SDK to upload files.  Read more...
By Additional Articles 2018/10/04 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,149 reads

Introducing SQL Server SSRS in Windows Containers

Learn how to deploy Reporting Services into a container with Windocks.  Read more...
By Paul Stanton 2018/10/04 | Source: SQLServerCentral.com | Category: containers
Rating: (not yet rated) |  Discuss |   Briefcase | 904 reads

Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption

In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.  Read more...
By Additional Articles 2018/10/03 | Source: MSSQLTips.com | Category: dbcc
Rating: (not yet rated)  Rate this |   Briefcase | 2,427 reads

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2018/10/03 (first published: 2017/05/24) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,468 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/10/03 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 101,766 reads

Modern Data Warehouse Design Pattern – Part II

Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.  Read more...
By Additional Articles 2018/10/02 | Source: Database Journal | Category: design pattern
Rating: (not yet rated)  Rate this |   Briefcase | 3,405 reads

Who's Using the DAC?

Learn how you can determine which connection is using the Dedicated Administrator Connection.  Read more...
Rating: |  Discuss |   Briefcase | 959 reads

Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption

In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.  Read more...
By Additional Articles 2018/10/01 | Source: MSSQLTips.com | Category: corruption
Rating: (not yet rated)  Rate this |   Briefcase | 1,993 reads

Exhuming the GDPR Bodies

Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares  Read more...
By Additional Articles 2018/10/01 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 reads

Compress and Decompress in SQL Server 2016

Explore using Compress/Decompress with varying types of data and examine size/storage usage  Read more...
By David Fundakowski 2018/10/01 | Source: SQLServerCentral.com | Category: compress()
Rating: |  Discuss |   Briefcase | 750 reads