Subscribe to this list via RSS Blog posts tagged in SQL Server
Secrets of FireDAC: Pagination With Grids And LiveBindings If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common pattern when doing web development to give the user 20 results for example and then the ability to move to the next page. If you are implementing a REST API in RAD Server you might also implement this functionality instead of delivering 2 million rows for the query you only deliver the first 20 rows and the next 20 can be requested in the next call. Obviou...
Ubuntu(FireDAC)を使ってMS SQL Server(RDS)に接続する。[JAPAN] 毛利です。   UbuntuのFireDACからAWS(RDS)上のSQL Server Express(2016 13.00)に接続を試してみました。 [SQL Server Expressのインスタンスを作成] AWS(RDS)からインスタンスの作成「DBインスタンス起動」します エンジンの選択で「Microsoft SQL Server Express Edition」を選択 設定が色々出て来ます。 DB Engine="SQL Server2016", Time Zone=Tokyoに設定。     [UbuntuにMicrosoft ODBC Driver 11 for SQL Serverをインストール] Ubuntu側にMicrosoft ODBC Driver 11 for SQL Serverをインストールします。 http://docwiki.embarcadero.com/RADStudio/Tokyo/ja/Microsoft_SQL_Server_への接続(FireDAC) # su...
Easy install SQL Server driver in Ubuntu It's quite exciting to develop Delphi and C++ Builder applications for Linux using the brand new RAD Studio 10.2 Tokyo release. So I can imagine that many developers are now starting new projects targeting Linux, or adapting their existing ones to the new platform. Many of these projects will surely use database connections, and the most widely used Enterprise database engine is Microsoft SQL Server (acording to different surveys).
In the C++Builder of RAD Server, FireDAC + SQLServer connection.[JAPAN] I explained the FireDAC + SQL Server connection in the previous parallel processing. // Use FireDAC to MSSQL Server in parallel(std::vector<std::thread>)[JAPAN] The "japan post office data"(SQL import) used last time is used from RAD Server. We will create a new RAD Server project this time. That's C++Builder. I have created one resource data module(TTestResource1). And we prepared a data module(TDataModule2) for one FireDAC. We will create a single suffix for the resource. It is a mem...
Use FireDAC to MSSQL Server in parallel(std::vector<std::thread>)[JAPAN] std::thread exists.It is in the standard from C++11. Insert data in MS-SQL Server in this way. The data is a Japanese address CSV. that is, It is in the post office in Japan web site. The data looks something like this. "0600000","北海道","札幌市 中央区","以下に掲載がない場合","HOKKAIDO","SAPPORO SHI CHUO KU","IKANIKEISAIGANAIBAAI" "0640941","北海道","札幌市 中央区","旭ケ丘","HOKKAIDO","SAPPORO SHI CHUO KU","ASAHIGAOKA" "0600041","北海道","札幌市 中央区","大通東","HOKKAIDO","SAPPORO SHI CHUO KU","ODORIHIGASHI" It is a CSV mixed...
Creating and Identifying Deadlocks in SQL Server This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health extended event. Get the ultimate tool suite for cross-platform database management Embarcadero DB PowerStudio, a suite of award-winning database tools for DBAs and data professionals, uniquely offers comprehensive administration, development and performance tuning capabilities across all major database platforms which dramatically increases productivi...
Learn How to Make your SQL Server Queries Run Faster If you are using Microsoft SQL Server, here's a webinar that you won't want to miss. Make SQL Server Queries Run Faster Wednesday, May 20, 201511:00am Pacific / 1:00pm Central / 2:00pm Eastern Have you ever developed slowly running queries and wondered how to tune your own SQL Server queries? In this session, you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go o...
SQL Server Tip: Optimizer using Index Scan and not Seek! Other than coding, most of the time developers have to troubleshoot problems from their environments. Developers in SQL world would mostly face problems around error message, getting required output via T-SQL query and unpredictable performance of query.  One fine day somewhere in the world a one developer was troubleshooting a performance problem – just like any one of us. He noticed, even after a table has index on a column and if they use that column in where clause, SQL Server was...
Performance Improvements with SQL Server 2014 Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay little more than previous model. Above theory holds good for SQL Server product as well. It is expected that SQL Server 2014 should have some new enhancements as compared to the predecessor SQL Server 2012 version. In SQL Server 20...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...

Check out more tips and tricks in this development video: