SQL Joker - blog

Friday, December 1, 2017

Data Modelers - Alternatives to Erwin

SQLServerCentral » Latest topics

Data Modelers - Alternatives to Erwin

I have been asked to find data modeling tools to serve as an alternative to Computer Associate's Erwin. I downloaded Toad version 3 to test it, but it doesn't allow me to import .er1 model diagrams. Does anyone know of decent alternatives to Erwin whi

Troubleshooting a SSRS related error

SQLServerCentral » Latest topics

Troubleshooting a SSRS related error

We have an Enterprise vendor application for student system.
We have our some customized pages that using SSRS reports.

It is in an HTML put into powerschool site, but has an iframe that hosted a report viewer that connects to a SSRS report i

General question on tuning

SQLServerCentral » Latest topics

General question on tuning

Hi All

Need some suggestions and clarity. Its a general basic question on Query tuning.

Is there any difference(s) when it comes to query tuning of a Azure database and OnPremise database?
In one of our env, they are looking for so

Bones of SQL - Practical Calendar Queries

SQLServerCentral » Latest topics

Bones of SQL - Practical Calendar Queries

Comments posted to this topic are about the item [B]Bones of SQL - Practical Calendar Queries[/B]

sql injection help

SQLServerCentral » Latest topics

sql injection help

Hello All,
I have an unusual request today.
My company has a very old Access VBA application, this application uses inline sql to read, insert ect.. into our Azure DB. I am not sure what version this DB is.

This inline sql tha

Flat file connection manager

SQLServerCentral » Latest topics

Flat file connection manager

I'm creating a flat file with a fixed length of 490 characters. Here's a snapshot from the Advanced page in the connection manager.

Are the posted questions getting worse?

SQLServerCentral » Latest topics

Are the posted questions getting worse?

Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server. It seems like the general feeling of a lot

SSMS breakpoint won't add

SQLServerCentral » Latest topics

SSMS breakpoint won't add

I'm having an issue in SSMS 2014 where I'm trying to debug a sql script and everytime I try to add a breakpoint ssms becomes unresponsive and won't add the breakpoint. I then have to close ssms via the task manager. Any recommendations on what could

How to resolve Multiple lookup operation in execution plan for same index

SQLServerCentral » Latest topics

How to resolve Multiple lookup operation in execution plan for same index

In a Query Block, We are using a table (CustomerOpenOrder) multiple time to join with other tables. In Execution plan, Lookup operation for that table is showing multiple times , attaching the complete query

Not Useless Features

SQLServerCentral » Latest topics

Not Useless Features

Comments posted to this topic are about the item [B]Not Useless Features[/B]

Setting column extended properties in Azure DW

SQLServerCentral » Latest topics

Setting column extended properties in Azure DW

Hi,

Though sys

SQL Server - Convert HEX value to ASCII value

SQLServerCentral » Latest topics

SQL Server - Convert HEX value to ASCII value

Can you please help with converting Hex Value to ASCII Value using SQL Server ? below is the value
Hex Value : - 刀椀瘀攀爀猀椀搀攀
ASCII Value :

Connect to server/database via VPN

SQLServerCentral » Latest topics

Connect to server/database via VPN

Hi,
I have a new client where I need to connect to their SQL database via a VPN using Palo Alto GlobalProtect client. My only experience of working with remote access is via remote desktop, which was very easy. So I am currently not sure what I need t

SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

SQLServerCentral » Latest topics

SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

I have 1 pair of identical server with SQL server 2008 R2 is installed.I have 2 databases in it which are mirrored.
Frequently I am facing disk full issue as the transaction logs gets full frequently. (with in 5 days it becomes 260 GB for 1 database).

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS

SQLServerCentral.com Articles

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS

In this demo heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS.

Subscribe to: Posts (Atom)